DBA Data[Home] [Help]

APPS.PER_ES_SS_REP_ARCHIVE_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 57: ,pay_assignment_actions paa1

53: AND pact.action_context_type = 'PA'
54: AND EXISTS ( SELECT 1
55: FROM pay_payroll_actions ppa1
56: ,pay_action_information pact_tra
57: ,pay_assignment_actions paa1
58: WHERE ppa1.payroll_action_id = ppa.payroll_action_id
59: AND pact_tra.action_information_category = 'ES_SS_REPORT_TRA'
60: AND pact_tra.action_context_type = 'AAP'
61: AND ppa1.payroll_action_id = paa1.payroll_action_id

Line 112: ,pay_assignment_actions paa

108: ('DAYS_PERCENT_APPLIES=P'),LPAD(NVL(pact_tra.action_information20,'0'),3,'0'),
109: ('RETIREMENT_REDUCTION_PERCENT=P'),LPAD(NVL(pact_tra.action_information21,'0'),2,'0'),
110: ('TEST_FLAG=P'),pact_tra.action_information22 -- not used
111: FROM pay_payroll_actions ppa
112: ,pay_assignment_actions paa
113: ,pay_action_information pact_tra
114: ,pay_action_information pact_fab
115: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
116: AND paa.payroll_action_id = ppa.payroll_action_id