DBA Data[Home] [Help]

APPS.PAY_PAYSLIP_REPORT dependencies on PAY_MAGTAPE_GENERIC

Line 40: AND ptoa.payroll_action_id = TO_NUMBER(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'))

36: ,per_assignment_status_types past
37: ,per_person_types ppt
38: WHERE ptoa.object_id = paaf.assignment_id
39: AND paaf.person_id = papf.person_id
40: AND ptoa.payroll_action_id = TO_NUMBER(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'))
41: AND ptoa.payroll_action_id = ppa.payroll_action_id
42: AND paaf.effective_start_date = (SELECT MAX(paf_inner.effective_start_date)
43: FROM per_all_assignments_f paf_inner
44: WHERE paf_inner.assignment_id = paaf.assignment_id

Line 103: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')

99: ,paaf.assignment_number ;
100: --
101: CURSOR csr_curr_act IS
102: SELECT 'TRANSFER_ACT_ID=P',
103: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
104: FROM DUAL;
105: --
106: PROCEDURE xml_asg;
107: --