DBA Data[Home] [Help]

APPS.PAY_SE_PAYSLIP_REPORT dependencies on PAY_ASSIGNMENT_ACTIONS

Line 137: FROM pay_assignment_actions paa

133: ,c_pa_token VARCHAR2
134: ,c_cs_token VARCHAR2
135: ,c_legislation_code VARCHAR2) IS
136: SELECT 'Y'
137: FROM pay_assignment_actions paa
138: ,pay_payroll_actions ppa
139: ,hr_lookups hrl
140: ,pay_action_information pai
141: ,per_time_periods ptp

Line 173: FROM pay_assignment_actions paa

169: ,c_cs_token VARCHAR2
170: ,c_legislation_code VARCHAR2
171: ,c_assignment_set_id NUMBER ) IS
172: SELECT 'Y'
173: FROM pay_assignment_actions paa
174: ,pay_payroll_actions ppa
175: ,hr_assignment_set_amendments hasa
176: ,hr_lookups hrl
177: ,pay_action_information pai

Line 359: PAY_ASSIGNMENT_ACTIONS PAA,

355: CURSOR csr_assg_id(p_payroll_id NUMBER,p_start_date VARCHAR2, p_end_date VARCHAR2)
356: IS
357: SELECT PAF.ASSIGNMENT_ID assignment_id
358: FROM PER_ALL_ASSIGNMENTS_F PAF,
359: PAY_ASSIGNMENT_ACTIONS PAA,
360: PAY_PAYROLL_ACTIONS PPA
361: WHERE PAF.payroll_id=p_payroll_id
362: AND PPA.PAYROLL_ACTION_ID=PAA.PAYROLL_ACTION_ID
363: AND PAF.ASSIGNMENT_ID=PAA.ASSIGNMENT_ID

Line 578: ,pay_assignment_Actions paa

574: ,c_legislation_code VARCHAR2) IS
575: SELECT pai.action_context_id
576: FROM pay_temp_object_actions ptoa
577: ,pay_action_information pai
578: ,pay_assignment_Actions paa
579: ,pay_payroll_actions ppa
580: ,hr_lookups hrl
581: WHERE ptoa.object_Action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
582: AND ptoa.object_id = paa.assignment_id