DBA Data[Home] [Help]

APPS.PAY_PAYSLIP_REPORT dependencies on PAY_MAGTAPE_GENERIC

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

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

Line 114: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')

110: ,paaf.assignment_number ;
111: --
112: CURSOR csr_curr_act IS
113: SELECT 'TRANSFER_ACT_ID=P',
114: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
115: FROM DUAL;
116: --
117: PROCEDURE xml_asg;
118: --