eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PAY_PAYROLL_ACTIONS_V6

Source

View Text - Preformatted


SELECT pac1.rowid row_id , pac1.payroll_id , pac1.payroll_action_id , pac1.effective_date , hr_payrolls.display_period_name (pac1.payroll_action_id) period_name , decode (pac1.action_type, 'H' , nvl (pay_payroll_actions_pkg.decode_cheque_type (pac1.business_group_id), hr_general.decode_lookup ('ACTION_TYPE', pac1.action_type)), hr_general.decode_lookup ('ACTION_TYPE', pac1.action_type)) meaning , pay_payroll_actions_pkg.v_name (pac1.payroll_action_id, pac1.action_type , pac1.consolidation_set_id, pac1.display_run_number , pac1.element_set_id, pac1.assignment_set_id , pac1.effective_date) name , pac1.action_type , pro.payroll_name , pac1.action_status status_code , pay_payroll_actions_pkg.v_action_status (pac1.payroll_action_id, pac1.action_status , pac1.request_id) action_status , pac1.action_sequence , pay_payroll_actions_pkg.v_messages_exist (pac1.payroll_action_id) messages_exist , pac1.request_id FROM pay_payrolls_f pro , pay_payroll_actions pac1 WHERE pac1.payroll_id = pro.payroll_id AND pac1.effective_date BETWEEN pro.effective_start_date AND pro.effective_end_date AND pac1.action_status <> 'U' AND pac1.action_type = nvl (pay_payroll_actions_pkg.get_char_bindvar ('ACTION_TYPE'), pac1.action_type) AND pac1.business_group_id + 0 = pay_payroll_actions_pkg.get_num_bindvar ('BUSINESS_GROUP_ID') AND ( pay_payroll_actions_pkg.get_num_bindvar ('PAYROLL_ID') IS NULL OR pac1.payroll_id = pay_payroll_actions_pkg.get_num_bindvar ('PAYROLL_ID') ) AND ( EXISTS ( SELECT 'x' FROM pay_assignment_actions aa , per_assignments_f2 paf , pay_payrolls_f pro1 WHERE pac1.action_type <> 'BEE' AND paf.payroll_id = pro1.payroll_id AND pro1.payroll_id = pay_payroll_actions_pkg.get_num_bindvar ('PAYROLL_ID') AND pac1.effective_date BETWEEN pro1.effective_start_date AND pro1.effective_end_date AND aa.payroll_action_id = pac1.payroll_action_id AND pac1.effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date AND aa.assignment_id = paf.assignment_id ) OR EXISTS ( SELECT 'x' FROM pay_assignment_actions aa , per_assignments_f2 paf , pay_payrolls_f pro1 WHERE pac1.action_type = 'BEE' AND paf.payroll_id = pro1.payroll_id AND pro1.payroll_id = pay_payroll_actions_pkg.get_num_bindvar ('PAYROLL_ID') AND aa.payroll_action_id = pac1.payroll_action_id AND aa.assignment_id = paf.assignment_id ) OR NOT EXISTS ( SELECT 'x' FROM pay_assignment_actions aa WHERE aa.payroll_action_id = pac1.payroll_action_id ) OR ( pay_payroll_actions_pkg.get_num_bindvar ('PAYROLL_ID') IS NULL ) ) AND (( pay_payroll_actions_pkg.get_char_bindvar ('ACTION_TYPE') in ('R','Q') AND pac1.date_earned >= pay_payroll_actions_pkg.get_date_bindvar ('PERIOD_DATE_FROM') AND pac1.date_earned <= pay_payroll_actions_pkg.get_date_bindvar ('PERIOD_DATE_TO')) or ( nvl(pay_payroll_actions_pkg.get_char_bindvar ('ACTION_TYPE'),'X') <> 'R' AND nvl (pac1.date_earned, pac1.effective_date) >= pay_payroll_actions_pkg.get_date_bindvar ('PERIOD_DATE_FROM') AND nvl (pac1.date_earned, pac1.effective_date) <= pay_payroll_actions_pkg.get_date_bindvar ('PERIOD_DATE_TO'))) AND ( pay_payroll_actions_pkg.get_char_bindvar ('SERVER_VALIDATE') = 'Y' OR ( pay_payroll_actions_pkg.get_char_bindvar ('SERVER_VALIDATE') = 'N' AND pay_payroll_actions_pkg.get_num_bindvar ('PAYROLL_ID') IS NOT NULL ) ) UNION ALL SELECT pac1.rowid row_id , pac1.payroll_id , pac1.payroll_action_id , pac1.effective_date , hr_payrolls.display_period_name (pac1.payroll_action_id) period_name , decode (pac1.action_type, 'H' , nvl (pay_payroll_actions_pkg.decode_cheque_type (pac1.business_group_id), hr_general.decode_lookup ('ACTION_TYPE', pac1.action_type)), hr_general.decode_lookup ('ACTION_TYPE', pac1.action_type)) meaning , pay_payroll_actions_pkg.v_name (pac1.payroll_action_id, pac1.action_type , pac1.consolidation_set_id, pac1.display_run_number , pac1.element_set_id, pac1.assignment_set_id , pac1.effective_date) name , pac1.action_type , pro.payroll_name , pac1.action_status status_code , pay_payroll_actions_pkg.v_action_status (pac1.payroll_action_id, pac1.action_status , pac1.request_id) action_status , pac1.action_sequence , pay_payroll_actions_pkg.v_messages_exist (pac1.payroll_action_id) messages_exist , pac1.request_id FROM pay_payrolls_f pro , pay_payroll_actions pac1 WHERE pac1.payroll_id = pro.payroll_id AND pac1.effective_date BETWEEN pro.effective_start_date AND pro.effective_end_date AND pac1.action_status <> 'U' AND pac1.action_type = nvl (pay_payroll_actions_pkg.get_char_bindvar ('ACTION_TYPE'), pac1.action_type) AND pac1.business_group_id + 0 = pay_payroll_actions_pkg.get_num_bindvar ('BUSINESS_GROUP_ID') AND ( pac1.payroll_id IS NULL OR pay_payroll_actions_pkg.get_num_bindvar ('PAYROLL_ID') IS NULL OR pac1.payroll_id = pay_payroll_actions_pkg.get_num_bindvar ('PAYROLL_ID') ) AND (( pay_payroll_actions_pkg.get_char_bindvar ('ACTION_TYPE') in ('R','Q') AND pac1.date_earned >= pay_payroll_actions_pkg.get_date_bindvar ('PERIOD_DATE_FROM') AND pac1.date_earned <= pay_payroll_actions_pkg.get_date_bindvar ('PERIOD_DATE_TO')) or ( nvl(pay_payroll_actions_pkg.get_char_bindvar ('ACTION_TYPE'),'X') <> 'R' AND nvl (pac1.date_earned, pac1.effective_date) >= pay_payroll_actions_pkg.get_date_bindvar ('PERIOD_DATE_FROM') AND nvl (pac1.date_earned, pac1.effective_date) <= pay_payroll_actions_pkg.get_date_bindvar ('PERIOD_DATE_TO'))) AND pay_payroll_actions_pkg.get_char_bindvar ('SERVER_VALIDATE') = 'N' AND pay_payroll_actions_pkg.get_num_bindvar ('PAYROLL_ID') IS NULL UNION ALL SELECT pac1.rowid row_id , pac1.payroll_id , pac1.payroll_action_id , pac1.effective_date , hr_payrolls.display_period_name (pac1.payroll_action_id) period_name , decode (pac1.action_type, 'H' , nvl (pay_payroll_actions_pkg.decode_cheque_type (pac1.business_group_id), hr_general.decode_lookup ('ACTION_TYPE', pac1.action_type)), hr_general.decode_lookup ('ACTION_TYPE', pac1.action_type)) meaning , pay_payroll_actions_pkg.v_name (pac1.payroll_action_id, pac1.action_type , pac1.consolidation_set_id, pac1.display_run_number , pac1.element_set_id, pac1.assignment_set_id , pac1.effective_date) name , pac1.action_type , NULL , pac1.action_status status_code , pay_payroll_actions_pkg.v_action_status (pac1.payroll_action_id, pac1.action_status , pac1.request_id) action_status , pac1.action_sequence , pay_payroll_actions_pkg.v_messages_exist (pac1.payroll_action_id) messages_exist , pac1.request_id FROM pay_payroll_actions pac1 WHERE pac1.payroll_id IS NULL AND pac1.action_status <> 'U' AND pac1.action_type = nvl (pay_payroll_actions_pkg.get_char_bindvar ('ACTION_TYPE'), pac1.action_type) AND pac1.business_group_id + 0 = pay_payroll_actions_pkg.get_num_bindvar ('BUSINESS_GROUP_ID') AND ( pac1.payroll_id IS NULL OR pay_payroll_actions_pkg.get_num_bindvar ('PAYROLL_ID') IS NULL OR pac1.payroll_id = pay_payroll_actions_pkg.get_num_bindvar ('PAYROLL_ID') ) AND ( EXISTS ( SELECT 'x' FROM pay_assignment_actions aa , per_assignments_f2 paf , pay_payrolls_f pro1 WHERE pac1.action_type <> 'BEE' AND paf.payroll_id = pro1.payroll_id AND pro1.payroll_id = pay_payroll_actions_pkg.get_num_bindvar ('PAYROLL_ID') AND pac1.effective_date BETWEEN pro1.effective_start_date AND pro1.effective_end_date AND aa.payroll_action_id = pac1.payroll_action_id AND pac1.effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date AND aa.assignment_id = paf.assignment_id ) OR EXISTS ( SELECT 'x' FROM pay_assignment_actions aa , per_assignments_f2 paf , pay_payrolls_f pro1 WHERE pac1.action_type = 'BEE' AND paf.payroll_id = pro1.payroll_id AND pro1.payroll_id = pay_payroll_actions_pkg.get_num_bindvar ('PAYROLL_ID') AND aa.payroll_action_id = pac1.payroll_action_id AND aa.assignment_id = paf.assignment_id ) OR NOT EXISTS ( SELECT 'x' FROM pay_assignment_actions aa WHERE aa.payroll_action_id = pac1.payroll_action_id ) OR ( pay_payroll_actions_pkg.get_num_bindvar ('PAYROLL_ID') IS NULL ) ) AND (( pay_payroll_actions_pkg.get_char_bindvar ('ACTION_TYPE') in ('R','Q') AND pac1.date_earned >= pay_payroll_actions_pkg.get_date_bindvar ('PERIOD_DATE_FROM') AND pac1.date_earned <= pay_payroll_actions_pkg.get_date_bindvar ('PERIOD_DATE_TO')) or ( nvl(pay_payroll_actions_pkg.get_char_bindvar ('ACTION_TYPE'),'X') <> 'R' AND nvl (pac1.date_earned, pac1.effective_date) >= pay_payroll_actions_pkg.get_date_bindvar ('PERIOD_DATE_FROM') AND nvl (pac1.date_earned, pac1.effective_date) <= pay_payroll_actions_pkg.get_date_bindvar ('PERIOD_DATE_TO'))) AND ( pay_payroll_actions_pkg.get_char_bindvar ('SERVER_VALIDATE') = 'Y' OR ( pay_payroll_actions_pkg.get_char_bindvar ('SERVER_VALIDATE') = 'N' AND pay_payroll_actions_pkg.get_num_bindvar ('PAYROLL_ID') IS NOT NULL ) ) UNION ALL SELECT pac1.rowid row_id , pac1.payroll_id , pac1.payroll_action_id , pac1.effective_date , hr_payrolls.display_period_name (pac1.payroll_action_id) period_name , decode (pac1.action_type, 'H' , nvl (pay_payroll_actions_pkg.decode_cheque_type (pac1.business_group_id), hr_general.decode_lookup ('ACTION_TYPE', pac1.action_type)), hr_general.decode_lookup ('ACTION_TYPE', pac1.action_type)) meaning , pay_payroll_actions_pkg.v_name (pac1.payroll_action_id, pac1.action_type , pac1.consolidation_set_id, pac1.display_run_number , pac1.element_set_id, pac1.assignment_set_id , pac1.effective_date) name , pac1.action_type , NULL , pac1.action_status status_code , pay_payroll_actions_pkg.v_action_status (pac1.payroll_action_id, pac1.action_status , pac1.request_id) action_status , pac1.action_sequence , pay_payroll_actions_pkg.v_messages_exist (pac1.payroll_action_id) messages_exist , pac1.request_id FROM pay_payroll_actions pac1 WHERE pac1.payroll_id IS NULL AND pac1.action_status <> 'U' AND pac1.action_type = nvl (pay_payroll_actions_pkg.get_char_bindvar ('ACTION_TYPE'), pac1.action_type) AND pac1.business_group_id + 0 = pay_payroll_actions_pkg.get_num_bindvar ('BUSINESS_GROUP_ID') AND ( pac1.payroll_id IS NULL OR pay_payroll_actions_pkg.get_num_bindvar ('PAYROLL_ID') IS NULL OR pac1.payroll_id = pay_payroll_actions_pkg.get_num_bindvar ('PAYROLL_ID') ) AND (( pay_payroll_actions_pkg.get_char_bindvar ('ACTION_TYPE') in ('R','Q') AND pac1.date_earned >= pay_payroll_actions_pkg.get_date_bindvar ('PERIOD_DATE_FROM') AND pac1.date_earned <= pay_payroll_actions_pkg.get_date_bindvar ('PERIOD_DATE_TO')) or ( nvl(pay_payroll_actions_pkg.get_char_bindvar ('ACTION_TYPE'),'X') <> 'R' AND nvl (pac1.date_earned, pac1.effective_date) >= pay_payroll_actions_pkg.get_date_bindvar ('PERIOD_DATE_FROM') AND nvl (pac1.date_earned, pac1.effective_date) <= pay_payroll_actions_pkg.get_date_bindvar ('PERIOD_DATE_TO'))) AND pay_payroll_actions_pkg.get_char_bindvar ('SERVER_VALIDATE') = 'N' AND pay_payroll_actions_pkg.get_num_bindvar ('PAYROLL_ID') IS NULL

View Text - HTML Formatted

SELECT PAC1.ROWID ROW_ID
, PAC1.PAYROLL_ID
, PAC1.PAYROLL_ACTION_ID
, PAC1.EFFECTIVE_DATE
, HR_PAYROLLS.DISPLAY_PERIOD_NAME (PAC1.PAYROLL_ACTION_ID) PERIOD_NAME
, DECODE (PAC1.ACTION_TYPE
, 'H'
, NVL (PAY_PAYROLL_ACTIONS_PKG.DECODE_CHEQUE_TYPE (PAC1.BUSINESS_GROUP_ID)
, HR_GENERAL.DECODE_LOOKUP ('ACTION_TYPE'
, PAC1.ACTION_TYPE))
, HR_GENERAL.DECODE_LOOKUP ('ACTION_TYPE'
, PAC1.ACTION_TYPE)) MEANING
, PAY_PAYROLL_ACTIONS_PKG.V_NAME (PAC1.PAYROLL_ACTION_ID
, PAC1.ACTION_TYPE
, PAC1.CONSOLIDATION_SET_ID
, PAC1.DISPLAY_RUN_NUMBER
, PAC1.ELEMENT_SET_ID
, PAC1.ASSIGNMENT_SET_ID
, PAC1.EFFECTIVE_DATE) NAME
, PAC1.ACTION_TYPE
, PRO.PAYROLL_NAME
, PAC1.ACTION_STATUS STATUS_CODE
, PAY_PAYROLL_ACTIONS_PKG.V_ACTION_STATUS (PAC1.PAYROLL_ACTION_ID
, PAC1.ACTION_STATUS
, PAC1.REQUEST_ID) ACTION_STATUS
, PAC1.ACTION_SEQUENCE
, PAY_PAYROLL_ACTIONS_PKG.V_MESSAGES_EXIST (PAC1.PAYROLL_ACTION_ID) MESSAGES_EXIST
, PAC1.REQUEST_ID
FROM PAY_PAYROLLS_F PRO
, PAY_PAYROLL_ACTIONS PAC1
WHERE PAC1.PAYROLL_ID = PRO.PAYROLL_ID
AND PAC1.EFFECTIVE_DATE BETWEEN PRO.EFFECTIVE_START_DATE
AND PRO.EFFECTIVE_END_DATE
AND PAC1.ACTION_STATUS <> 'U'
AND PAC1.ACTION_TYPE = NVL (PAY_PAYROLL_ACTIONS_PKG.GET_CHAR_BINDVAR ('ACTION_TYPE')
, PAC1.ACTION_TYPE)
AND PAC1.BUSINESS_GROUP_ID + 0 = PAY_PAYROLL_ACTIONS_PKG.GET_NUM_BINDVAR ('BUSINESS_GROUP_ID')
AND ( PAY_PAYROLL_ACTIONS_PKG.GET_NUM_BINDVAR ('PAYROLL_ID') IS NULL OR PAC1.PAYROLL_ID = PAY_PAYROLL_ACTIONS_PKG.GET_NUM_BINDVAR ('PAYROLL_ID') )
AND ( EXISTS ( SELECT 'X'
FROM PAY_ASSIGNMENT_ACTIONS AA
, PER_ASSIGNMENTS_F2 PAF
, PAY_PAYROLLS_F PRO1
WHERE PAC1.ACTION_TYPE <> 'BEE'
AND PAF.PAYROLL_ID = PRO1.PAYROLL_ID
AND PRO1.PAYROLL_ID = PAY_PAYROLL_ACTIONS_PKG.GET_NUM_BINDVAR ('PAYROLL_ID')
AND PAC1.EFFECTIVE_DATE BETWEEN PRO1.EFFECTIVE_START_DATE
AND PRO1.EFFECTIVE_END_DATE
AND AA.PAYROLL_ACTION_ID = PAC1.PAYROLL_ACTION_ID
AND PAC1.EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE
AND AA.ASSIGNMENT_ID = PAF.ASSIGNMENT_ID ) OR EXISTS ( SELECT 'X'
FROM PAY_ASSIGNMENT_ACTIONS AA
, PER_ASSIGNMENTS_F2 PAF
, PAY_PAYROLLS_F PRO1
WHERE PAC1.ACTION_TYPE = 'BEE'
AND PAF.PAYROLL_ID = PRO1.PAYROLL_ID
AND PRO1.PAYROLL_ID = PAY_PAYROLL_ACTIONS_PKG.GET_NUM_BINDVAR ('PAYROLL_ID')
AND AA.PAYROLL_ACTION_ID = PAC1.PAYROLL_ACTION_ID
AND AA.ASSIGNMENT_ID = PAF.ASSIGNMENT_ID ) OR NOT EXISTS ( SELECT 'X'
FROM PAY_ASSIGNMENT_ACTIONS AA
WHERE AA.PAYROLL_ACTION_ID = PAC1.PAYROLL_ACTION_ID ) OR ( PAY_PAYROLL_ACTIONS_PKG.GET_NUM_BINDVAR ('PAYROLL_ID') IS NULL ) )
AND (( PAY_PAYROLL_ACTIONS_PKG.GET_CHAR_BINDVAR ('ACTION_TYPE') IN ('R'
, 'Q')
AND PAC1.DATE_EARNED >= PAY_PAYROLL_ACTIONS_PKG.GET_DATE_BINDVAR ('PERIOD_DATE_FROM')
AND PAC1.DATE_EARNED <= PAY_PAYROLL_ACTIONS_PKG.GET_DATE_BINDVAR ('PERIOD_DATE_TO')) OR ( NVL(PAY_PAYROLL_ACTIONS_PKG.GET_CHAR_BINDVAR ('ACTION_TYPE')
, 'X') <> 'R'
AND NVL (PAC1.DATE_EARNED
, PAC1.EFFECTIVE_DATE) >= PAY_PAYROLL_ACTIONS_PKG.GET_DATE_BINDVAR ('PERIOD_DATE_FROM')
AND NVL (PAC1.DATE_EARNED
, PAC1.EFFECTIVE_DATE) <= PAY_PAYROLL_ACTIONS_PKG.GET_DATE_BINDVAR ('PERIOD_DATE_TO')))
AND ( PAY_PAYROLL_ACTIONS_PKG.GET_CHAR_BINDVAR ('SERVER_VALIDATE') = 'Y' OR ( PAY_PAYROLL_ACTIONS_PKG.GET_CHAR_BINDVAR ('SERVER_VALIDATE') = 'N'
AND PAY_PAYROLL_ACTIONS_PKG.GET_NUM_BINDVAR ('PAYROLL_ID') IS NOT NULL ) ) UNION ALL SELECT PAC1.ROWID ROW_ID
, PAC1.PAYROLL_ID
, PAC1.PAYROLL_ACTION_ID
, PAC1.EFFECTIVE_DATE
, HR_PAYROLLS.DISPLAY_PERIOD_NAME (PAC1.PAYROLL_ACTION_ID) PERIOD_NAME
, DECODE (PAC1.ACTION_TYPE
, 'H'
, NVL (PAY_PAYROLL_ACTIONS_PKG.DECODE_CHEQUE_TYPE (PAC1.BUSINESS_GROUP_ID)
, HR_GENERAL.DECODE_LOOKUP ('ACTION_TYPE'
, PAC1.ACTION_TYPE))
, HR_GENERAL.DECODE_LOOKUP ('ACTION_TYPE'
, PAC1.ACTION_TYPE)) MEANING
, PAY_PAYROLL_ACTIONS_PKG.V_NAME (PAC1.PAYROLL_ACTION_ID
, PAC1.ACTION_TYPE
, PAC1.CONSOLIDATION_SET_ID
, PAC1.DISPLAY_RUN_NUMBER
, PAC1.ELEMENT_SET_ID
, PAC1.ASSIGNMENT_SET_ID
, PAC1.EFFECTIVE_DATE) NAME
, PAC1.ACTION_TYPE
, PRO.PAYROLL_NAME
, PAC1.ACTION_STATUS STATUS_CODE
, PAY_PAYROLL_ACTIONS_PKG.V_ACTION_STATUS (PAC1.PAYROLL_ACTION_ID
, PAC1.ACTION_STATUS
, PAC1.REQUEST_ID) ACTION_STATUS
, PAC1.ACTION_SEQUENCE
, PAY_PAYROLL_ACTIONS_PKG.V_MESSAGES_EXIST (PAC1.PAYROLL_ACTION_ID) MESSAGES_EXIST
, PAC1.REQUEST_ID
FROM PAY_PAYROLLS_F PRO
, PAY_PAYROLL_ACTIONS PAC1
WHERE PAC1.PAYROLL_ID = PRO.PAYROLL_ID
AND PAC1.EFFECTIVE_DATE BETWEEN PRO.EFFECTIVE_START_DATE
AND PRO.EFFECTIVE_END_DATE
AND PAC1.ACTION_STATUS <> 'U'
AND PAC1.ACTION_TYPE = NVL (PAY_PAYROLL_ACTIONS_PKG.GET_CHAR_BINDVAR ('ACTION_TYPE')
, PAC1.ACTION_TYPE)
AND PAC1.BUSINESS_GROUP_ID + 0 = PAY_PAYROLL_ACTIONS_PKG.GET_NUM_BINDVAR ('BUSINESS_GROUP_ID')
AND ( PAC1.PAYROLL_ID IS NULL OR PAY_PAYROLL_ACTIONS_PKG.GET_NUM_BINDVAR ('PAYROLL_ID') IS NULL OR PAC1.PAYROLL_ID = PAY_PAYROLL_ACTIONS_PKG.GET_NUM_BINDVAR ('PAYROLL_ID') )
AND (( PAY_PAYROLL_ACTIONS_PKG.GET_CHAR_BINDVAR ('ACTION_TYPE') IN ('R'
, 'Q')
AND PAC1.DATE_EARNED >= PAY_PAYROLL_ACTIONS_PKG.GET_DATE_BINDVAR ('PERIOD_DATE_FROM')
AND PAC1.DATE_EARNED <= PAY_PAYROLL_ACTIONS_PKG.GET_DATE_BINDVAR ('PERIOD_DATE_TO')) OR ( NVL(PAY_PAYROLL_ACTIONS_PKG.GET_CHAR_BINDVAR ('ACTION_TYPE')
, 'X') <> 'R'
AND NVL (PAC1.DATE_EARNED
, PAC1.EFFECTIVE_DATE) >= PAY_PAYROLL_ACTIONS_PKG.GET_DATE_BINDVAR ('PERIOD_DATE_FROM')
AND NVL (PAC1.DATE_EARNED
, PAC1.EFFECTIVE_DATE) <= PAY_PAYROLL_ACTIONS_PKG.GET_DATE_BINDVAR ('PERIOD_DATE_TO')))
AND PAY_PAYROLL_ACTIONS_PKG.GET_CHAR_BINDVAR ('SERVER_VALIDATE') = 'N'
AND PAY_PAYROLL_ACTIONS_PKG.GET_NUM_BINDVAR ('PAYROLL_ID') IS NULL UNION ALL SELECT PAC1.ROWID ROW_ID
, PAC1.PAYROLL_ID
, PAC1.PAYROLL_ACTION_ID
, PAC1.EFFECTIVE_DATE
, HR_PAYROLLS.DISPLAY_PERIOD_NAME (PAC1.PAYROLL_ACTION_ID) PERIOD_NAME
, DECODE (PAC1.ACTION_TYPE
, 'H'
, NVL (PAY_PAYROLL_ACTIONS_PKG.DECODE_CHEQUE_TYPE (PAC1.BUSINESS_GROUP_ID)
, HR_GENERAL.DECODE_LOOKUP ('ACTION_TYPE'
, PAC1.ACTION_TYPE))
, HR_GENERAL.DECODE_LOOKUP ('ACTION_TYPE'
, PAC1.ACTION_TYPE)) MEANING
, PAY_PAYROLL_ACTIONS_PKG.V_NAME (PAC1.PAYROLL_ACTION_ID
, PAC1.ACTION_TYPE
, PAC1.CONSOLIDATION_SET_ID
, PAC1.DISPLAY_RUN_NUMBER
, PAC1.ELEMENT_SET_ID
, PAC1.ASSIGNMENT_SET_ID
, PAC1.EFFECTIVE_DATE) NAME
, PAC1.ACTION_TYPE
, NULL
, PAC1.ACTION_STATUS STATUS_CODE
, PAY_PAYROLL_ACTIONS_PKG.V_ACTION_STATUS (PAC1.PAYROLL_ACTION_ID
, PAC1.ACTION_STATUS
, PAC1.REQUEST_ID) ACTION_STATUS
, PAC1.ACTION_SEQUENCE
, PAY_PAYROLL_ACTIONS_PKG.V_MESSAGES_EXIST (PAC1.PAYROLL_ACTION_ID) MESSAGES_EXIST
, PAC1.REQUEST_ID
FROM PAY_PAYROLL_ACTIONS PAC1
WHERE PAC1.PAYROLL_ID IS NULL
AND PAC1.ACTION_STATUS <> 'U'
AND PAC1.ACTION_TYPE = NVL (PAY_PAYROLL_ACTIONS_PKG.GET_CHAR_BINDVAR ('ACTION_TYPE')
, PAC1.ACTION_TYPE)
AND PAC1.BUSINESS_GROUP_ID + 0 = PAY_PAYROLL_ACTIONS_PKG.GET_NUM_BINDVAR ('BUSINESS_GROUP_ID')
AND ( PAC1.PAYROLL_ID IS NULL OR PAY_PAYROLL_ACTIONS_PKG.GET_NUM_BINDVAR ('PAYROLL_ID') IS NULL OR PAC1.PAYROLL_ID = PAY_PAYROLL_ACTIONS_PKG.GET_NUM_BINDVAR ('PAYROLL_ID') )
AND ( EXISTS ( SELECT 'X'
FROM PAY_ASSIGNMENT_ACTIONS AA
, PER_ASSIGNMENTS_F2 PAF
, PAY_PAYROLLS_F PRO1
WHERE PAC1.ACTION_TYPE <> 'BEE'
AND PAF.PAYROLL_ID = PRO1.PAYROLL_ID
AND PRO1.PAYROLL_ID = PAY_PAYROLL_ACTIONS_PKG.GET_NUM_BINDVAR ('PAYROLL_ID')
AND PAC1.EFFECTIVE_DATE BETWEEN PRO1.EFFECTIVE_START_DATE
AND PRO1.EFFECTIVE_END_DATE
AND AA.PAYROLL_ACTION_ID = PAC1.PAYROLL_ACTION_ID
AND PAC1.EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE
AND AA.ASSIGNMENT_ID = PAF.ASSIGNMENT_ID ) OR EXISTS ( SELECT 'X'
FROM PAY_ASSIGNMENT_ACTIONS AA
, PER_ASSIGNMENTS_F2 PAF
, PAY_PAYROLLS_F PRO1
WHERE PAC1.ACTION_TYPE = 'BEE'
AND PAF.PAYROLL_ID = PRO1.PAYROLL_ID
AND PRO1.PAYROLL_ID = PAY_PAYROLL_ACTIONS_PKG.GET_NUM_BINDVAR ('PAYROLL_ID')
AND AA.PAYROLL_ACTION_ID = PAC1.PAYROLL_ACTION_ID
AND AA.ASSIGNMENT_ID = PAF.ASSIGNMENT_ID ) OR NOT EXISTS ( SELECT 'X'
FROM PAY_ASSIGNMENT_ACTIONS AA
WHERE AA.PAYROLL_ACTION_ID = PAC1.PAYROLL_ACTION_ID ) OR ( PAY_PAYROLL_ACTIONS_PKG.GET_NUM_BINDVAR ('PAYROLL_ID') IS NULL ) )
AND (( PAY_PAYROLL_ACTIONS_PKG.GET_CHAR_BINDVAR ('ACTION_TYPE') IN ('R'
, 'Q')
AND PAC1.DATE_EARNED >= PAY_PAYROLL_ACTIONS_PKG.GET_DATE_BINDVAR ('PERIOD_DATE_FROM')
AND PAC1.DATE_EARNED <= PAY_PAYROLL_ACTIONS_PKG.GET_DATE_BINDVAR ('PERIOD_DATE_TO')) OR ( NVL(PAY_PAYROLL_ACTIONS_PKG.GET_CHAR_BINDVAR ('ACTION_TYPE')
, 'X') <> 'R'
AND NVL (PAC1.DATE_EARNED
, PAC1.EFFECTIVE_DATE) >= PAY_PAYROLL_ACTIONS_PKG.GET_DATE_BINDVAR ('PERIOD_DATE_FROM')
AND NVL (PAC1.DATE_EARNED
, PAC1.EFFECTIVE_DATE) <= PAY_PAYROLL_ACTIONS_PKG.GET_DATE_BINDVAR ('PERIOD_DATE_TO')))
AND ( PAY_PAYROLL_ACTIONS_PKG.GET_CHAR_BINDVAR ('SERVER_VALIDATE') = 'Y' OR ( PAY_PAYROLL_ACTIONS_PKG.GET_CHAR_BINDVAR ('SERVER_VALIDATE') = 'N'
AND PAY_PAYROLL_ACTIONS_PKG.GET_NUM_BINDVAR ('PAYROLL_ID') IS NOT NULL ) ) UNION ALL SELECT PAC1.ROWID ROW_ID
, PAC1.PAYROLL_ID
, PAC1.PAYROLL_ACTION_ID
, PAC1.EFFECTIVE_DATE
, HR_PAYROLLS.DISPLAY_PERIOD_NAME (PAC1.PAYROLL_ACTION_ID) PERIOD_NAME
, DECODE (PAC1.ACTION_TYPE
, 'H'
, NVL (PAY_PAYROLL_ACTIONS_PKG.DECODE_CHEQUE_TYPE (PAC1.BUSINESS_GROUP_ID)
, HR_GENERAL.DECODE_LOOKUP ('ACTION_TYPE'
, PAC1.ACTION_TYPE))
, HR_GENERAL.DECODE_LOOKUP ('ACTION_TYPE'
, PAC1.ACTION_TYPE)) MEANING
, PAY_PAYROLL_ACTIONS_PKG.V_NAME (PAC1.PAYROLL_ACTION_ID
, PAC1.ACTION_TYPE
, PAC1.CONSOLIDATION_SET_ID
, PAC1.DISPLAY_RUN_NUMBER
, PAC1.ELEMENT_SET_ID
, PAC1.ASSIGNMENT_SET_ID
, PAC1.EFFECTIVE_DATE) NAME
, PAC1.ACTION_TYPE
, NULL
, PAC1.ACTION_STATUS STATUS_CODE
, PAY_PAYROLL_ACTIONS_PKG.V_ACTION_STATUS (PAC1.PAYROLL_ACTION_ID
, PAC1.ACTION_STATUS
, PAC1.REQUEST_ID) ACTION_STATUS
, PAC1.ACTION_SEQUENCE
, PAY_PAYROLL_ACTIONS_PKG.V_MESSAGES_EXIST (PAC1.PAYROLL_ACTION_ID) MESSAGES_EXIST
, PAC1.REQUEST_ID
FROM PAY_PAYROLL_ACTIONS PAC1
WHERE PAC1.PAYROLL_ID IS NULL
AND PAC1.ACTION_STATUS <> 'U'
AND PAC1.ACTION_TYPE = NVL (PAY_PAYROLL_ACTIONS_PKG.GET_CHAR_BINDVAR ('ACTION_TYPE')
, PAC1.ACTION_TYPE)
AND PAC1.BUSINESS_GROUP_ID + 0 = PAY_PAYROLL_ACTIONS_PKG.GET_NUM_BINDVAR ('BUSINESS_GROUP_ID')
AND ( PAC1.PAYROLL_ID IS NULL OR PAY_PAYROLL_ACTIONS_PKG.GET_NUM_BINDVAR ('PAYROLL_ID') IS NULL OR PAC1.PAYROLL_ID = PAY_PAYROLL_ACTIONS_PKG.GET_NUM_BINDVAR ('PAYROLL_ID') )
AND (( PAY_PAYROLL_ACTIONS_PKG.GET_CHAR_BINDVAR ('ACTION_TYPE') IN ('R'
, 'Q')
AND PAC1.DATE_EARNED >= PAY_PAYROLL_ACTIONS_PKG.GET_DATE_BINDVAR ('PERIOD_DATE_FROM')
AND PAC1.DATE_EARNED <= PAY_PAYROLL_ACTIONS_PKG.GET_DATE_BINDVAR ('PERIOD_DATE_TO')) OR ( NVL(PAY_PAYROLL_ACTIONS_PKG.GET_CHAR_BINDVAR ('ACTION_TYPE')
, 'X') <> 'R'
AND NVL (PAC1.DATE_EARNED
, PAC1.EFFECTIVE_DATE) >= PAY_PAYROLL_ACTIONS_PKG.GET_DATE_BINDVAR ('PERIOD_DATE_FROM')
AND NVL (PAC1.DATE_EARNED
, PAC1.EFFECTIVE_DATE) <= PAY_PAYROLL_ACTIONS_PKG.GET_DATE_BINDVAR ('PERIOD_DATE_TO')))
AND PAY_PAYROLL_ACTIONS_PKG.GET_CHAR_BINDVAR ('SERVER_VALIDATE') = 'N'
AND PAY_PAYROLL_ACTIONS_PKG.GET_NUM_BINDVAR ('PAYROLL_ID') IS NULL