1. Tables and Views for HCM
  2. PAY_BL_ACTION_PARAMETERS_VL

PAY_BL_ACTION_PARAMETERS_VL

Details

  • Schema: FUSION

  • Object owner: PAY

  • Object type: VIEW

Columns

Name

ACTION_PARAMETER_ID

TASK_ACTION_ID

ACTION_PARAMETER_NAME

PARAMETER_NAMESPACE

PARAMETER_SEQUENCE

PARENT_ACTION_PARAMETER_ID

PARAMETER_NODE_TYPE

PARAMETER_KEY_STATUS

REF_TASK_ACTION_ID

DISPLAY_ACTION_PARAMETER_NAME

LEGISLATIVE_DATA_GROUP_ID

DISPLAY_FLAG

Query

SQL_Statement

SELECT PAY_TASK_PARAMETERS.BASE_TASK_PARAMETER_ID ACTION_PARAMETER_ID,

PAY_TASK_PARAMETERS.BASE_TASK_ACTION_ID TASK_ACTION_ID,

PAY_TASK_PARAMETERS.ELEMENT_NAME ACTION_PARAMETER_NAME,

PAY_TASK_PARAMETERS.NAMESPACE PARAMETER_NAMESPACE,

PAY_TASK_PARAMETERS.PARAM_SEQUENCE PARAMETER_SEQUENCE,

PAY_TASK_PARAMETERS.PARENT_TASK_PARAM_ID PARENT_ACTION_PARAMETER_ID,

DECODE(PAY_TASK_PARAMETERS.PARAM_LEVEL, 'INNER', 'I', 'LEAF', 'L', 'LOV', 'V', 'ROWSET', 'R', NULL) PARAMETER_NODE_TYPE,

PAY_TASK_PARAMETERS.PARAMETER_TYPE PARAMETER_KEY_STATUS,

PAY_TASK_PARAMETERS.REF_TASK_ACTION_ID REF_TASK_ACTION_ID,

PAY_TASK_PARAMETERS_TL.PARAMETER_NAME DISPLAY_ACTION_PARAMETER_NAME,

PAY_TASK_PARAMETERS.LEGISLATIVE_DATA_GROUP_ID,

PAY_TASK_PARAMETERS.DISPLAY_FLAG

FROM PAY_TASK_ACTIONS,

PAY_TASK_USAGE,

PAY_TASK_PARAMETERS,

PAY_TASK_PARAMETERS_TL

WHERE PAY_TASK_ACTIONS.BASE_TASK_ID = PAY_TASK_USAGE.BASE_TASK_ID

AND PAY_TASK_USAGE.USAGE_TYPE = 'BATCH_LOADER'

AND PAY_TASK_PARAMETERS.BASE_TASK_ACTION_ID = PAY_TASK_ACTIONS.BASE_TASK_ACTION_ID

AND PAY_TASK_PARAMETERS_TL.TASK_PARAMETER_ID = PAY_TASK_PARAMETERS.TASK_PARAMETER_ID

AND PAY_TASK_PARAMETERS_TL.LANGUAGE = USERENV('LANG')

AND PAY_TASK_USAGE.base_task_usage_name NOT IN ('ELEMENT_ENTRY','ELEMENT','ELEMENT_TEMPLATE')

UNION

SELECT PAY_TASK_PARAMETERS.BASE_TASK_PARAMETER_ID ACTION_PARAMETER_ID,

pet.element_type_id TASK_ACTION_ID,

PAY_TASK_PARAMETERS.ELEMENT_NAME ACTION_PARAMETER_NAME, nvl(PAY_TASK_PARAMETERS.NAMESPACE,'http://xmlns.oracle.com/apps/hcm/payrolls/elements/entries/payrollElementEntryService/applicationModule/types/') PARAMETER_NAMESPACE,

PAY_TASK_PARAMETERS.PARAM_SEQUENCE PARAMETER_SEQUENCE,

PAY_TASK_PARAMETERS.PARENT_TASK_PARAM_ID PARENT_ACTION_PARAMETER_ID,

DECODE(PAY_TASK_PARAMETERS.PARAM_LEVEL, 'INNER', 'I', 'LEAF', 'L', 'LOV', 'V', 'ROWSET', 'R', NULL) PARAMETER_NODE_TYPE,

PAY_TASK_PARAMETERS.PARAMETER_TYPE PARAMETER_KEY_STATUS,

PAY_TASK_PARAMETERS.REF_TASK_ACTION_ID REF_TASK_ACTION_ID,

DECODE(substrb(PAY_TASK_PARAMETERS.BASE_TASK_PARAMETER_NAME,1,11),'INPUT_VALUE', PAY_BATCH_LDR_PKG.column_name(pet.element_type_id,substrb(PAY_TASK_PARAMETERS.BASE_TASK_PARAMETER_NAME,13),PAY_TASK_USAGE.base_task_usage_name), PAY_TASK_PARAMETERS_TL.PARAMETER_NAME) DISPLAY_ACTION_PARAMETER_NAME,

PAY_TASK_PARAMETERS.LEGISLATIVE_DATA_GROUP_ID,

DECODE(substrb(PAY_TASK_PARAMETERS.BASE_TASK_PARAMETER_NAME,1,11),'INPUT_VALUE', DECODE(PAY_BATCH_LDR_PKG.column_name(pet.element_type_id,substrb(PAY_TASK_PARAMETERS.BASE_TASK_PARAMETER_NAME,13),PAY_TASK_USAGE.base_task_usage_name), NULL,'N','Y'), PAY_TASK_PARAMETERS.DISPLAY_FLAG) DISPLAY_FLAG

FROM PAY_TASK_ACTIONS,

PAY_TASK_USAGE,

PAY_TASK_PARAMETERS,

PAY_TASK_PARAMETERS_TL,

pay_element_types_vl pet

WHERE PAY_TASK_ACTIONS.BASE_TASK_ID = PAY_TASK_USAGE.BASE_TASK_ID

AND PAY_TASK_USAGE.USAGE_TYPE = 'BATCH_LOADER'

AND PAY_TASK_PARAMETERS.BASE_TASK_ACTION_ID = PAY_TASK_ACTIONS.BASE_TASK_ACTION_ID

AND PAY_TASK_PARAMETERS_TL.TASK_PARAMETER_ID = PAY_TASK_PARAMETERS.TASK_PARAMETER_ID

AND PAY_TASK_PARAMETERS_TL.LANGUAGE = USERENV('LANG')

AND PAY_TASK_USAGE.base_task_usage_name = 'ELEMENT_ENTRY'

UNION

SELECT PAY_TASK_PARAMETERS.BASE_TASK_PARAMETER_ID ACTION_PARAMETER_ID,

pet.template_id*-1 TASK_ACTION_ID,

PAY_TASK_PARAMETERS.ELEMENT_NAME ACTION_PARAMETER_NAME,

PAY_TASK_PARAMETERS.NAMESPACE PARAMETER_NAMESPACE,

PAY_TASK_PARAMETERS.PARAM_SEQUENCE PARAMETER_SEQUENCE,

PAY_TASK_PARAMETERS.PARENT_TASK_PARAM_ID PARENT_ACTION_PARAMETER_ID,

DECODE(PAY_TASK_PARAMETERS.PARAM_LEVEL, 'INNER', 'I', 'LEAF', 'L', 'LOV', 'V', 'ROWSET', 'R', NULL) PARAMETER_NODE_TYPE,

PAY_TASK_PARAMETERS.PARAMETER_TYPE PARAMETER_KEY_STATUS,

PAY_TASK_PARAMETERS.REF_TASK_ACTION_ID REF_TASK_ACTION_ID,

DECODE(substrb(PAY_TASK_PARAMETERS.BASE_TASK_PARAMETER_NAME,1,4),'RULE', PAY_BATCH_LDR_PKG.column_name(pet.template_id,substrb(PAY_TASK_PARAMETERS.BASE_TASK_PARAMETER_NAME,5),PAY_TASK_USAGE.base_task_usage_name), PAY_TASK_PARAMETERS_TL.PARAMETER_NAME) DISPLAY_ACTION_PARAMETER_NAME,

PAY_TASK_PARAMETERS.LEGISLATIVE_DATA_GROUP_ID,

DECODE(substrb(PAY_TASK_PARAMETERS.BASE_TASK_PARAMETER_NAME,1,4),'RULE', DECODE(PAY_BATCH_LDR_PKG.column_name(pet.template_id,substrb(PAY_TASK_PARAMETERS.BASE_TASK_PARAMETER_NAME,5),PAY_TASK_USAGE.base_task_usage_name), NULL,'N','Y'), PAY_TASK_PARAMETERS.DISPLAY_FLAG) DISPLAY_FLAG

FROM PAY_TASK_ACTIONS,

PAY_TASK_USAGE,

PAY_TASK_PARAMETERS,

PAY_TASK_PARAMETERS_TL,

pay_templates pet

WHERE PAY_TASK_ACTIONS.BASE_TASK_ID = PAY_TASK_USAGE.BASE_TASK_ID

AND PAY_TASK_USAGE.USAGE_TYPE = 'BATCH_LOADER'

AND PAY_TASK_PARAMETERS.BASE_TASK_ACTION_ID = PAY_TASK_ACTIONS.BASE_TASK_ACTION_ID

AND PAY_TASK_PARAMETERS_TL.TASK_PARAMETER_ID = PAY_TASK_PARAMETERS.TASK_PARAMETER_ID

AND PAY_TASK_PARAMETERS_TL.LANGUAGE = USERENV('LANG')

AND PAY_TASK_USAGE.base_task_usage_name = 'ELEMENT'

AND pet.template_type ='T'

UNION

SELECT PAY_TASK_PARAMETERS.BASE_TASK_PARAMETER_ID ACTION_PARAMETER_ID,

pet.template_id TASK_ACTION_ID,

PAY_TASK_PARAMETERS.ELEMENT_NAME ACTION_PARAMETER_NAME,

PAY_TASK_PARAMETERS.NAMESPACE PARAMETER_NAMESPACE,

PAY_TASK_PARAMETERS.PARAM_SEQUENCE PARAMETER_SEQUENCE,

PAY_TASK_PARAMETERS.PARENT_TASK_PARAM_ID PARENT_ACTION_PARAMETER_ID,

DECODE(PAY_TASK_PARAMETERS.PARAM_LEVEL, 'INNER', 'I', 'LEAF', 'L', 'LOV', 'V', 'ROWSET', 'R', NULL) PARAMETER_NODE_TYPE,

PAY_TASK_PARAMETERS.PARAMETER_TYPE PARAMETER_KEY_STATUS,

PAY_TASK_PARAMETERS.REF_TASK_ACTION_ID REF_TASK_ACTION_ID,

DECODE(substrb(PAY_TASK_PARAMETERS.BASE_TASK_PARAMETER_NAME,1,4),'RULE', PAY_BATCH_LDR_PKG.column_name(pet.template_id,substrb(PAY_TASK_PARAMETERS.BASE_TASK_PARAMETER_NAME,5),PAY_TASK_USAGE.base_task_usage_name), PAY_TASK_PARAMETERS_TL.PARAMETER_NAME) DISPLAY_ACTION_PARAMETER_NAME,

PAY_TASK_PARAMETERS.LEGISLATIVE_DATA_GROUP_ID,

DECODE(substrb(PAY_TASK_PARAMETERS.BASE_TASK_PARAMETER_NAME,1,4),'RULE', DECODE(PAY_BATCH_LDR_PKG.column_name(pet.template_id,substrb(PAY_TASK_PARAMETERS.BASE_TASK_PARAMETER_NAME,5),PAY_TASK_USAGE.base_task_usage_name), NULL,'N','Y'), PAY_TASK_PARAMETERS.DISPLAY_FLAG) DISPLAY_FLAG

FROM PAY_TASK_ACTIONS,

PAY_TASK_USAGE,

PAY_TASK_PARAMETERS,

PAY_TASK_PARAMETERS_TL,

pay_templates pet

WHERE PAY_TASK_ACTIONS.BASE_TASK_ID = PAY_TASK_USAGE.BASE_TASK_ID

AND PAY_TASK_USAGE.USAGE_TYPE = 'BATCH_LOADER'

AND PAY_TASK_PARAMETERS.BASE_TASK_ACTION_ID = PAY_TASK_ACTIONS.BASE_TASK_ACTION_ID

AND PAY_TASK_PARAMETERS_TL.TASK_PARAMETER_ID = PAY_TASK_PARAMETERS.TASK_PARAMETER_ID

AND PAY_TASK_PARAMETERS_TL.LANGUAGE = USERENV('LANG')

AND PAY_TASK_USAGE.base_task_usage_name = 'ELEMENT_TEMPLATE'

AND pet.template_type ='T'