DBA Data[Home] [Help]

APPS.PAY_NO_PAYSLIP_REPORT dependencies on PAY_MAGTAPE_GENERIC

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

40: ,per_assignment_status_types past
41: ,per_person_types ppt
42: WHERE ptoa.object_id = paaf.assignment_id
43: AND paaf.person_id = papf.person_id
44: AND ptoa.payroll_action_id = TO_NUMBER(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'))
45: AND ptoa.payroll_action_id = ppa.payroll_action_id
46: AND paaf.effective_start_date <= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')
47: AND paaf.effective_end_date >= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'START_DATE'),'YYYY/MM/DD')
48: AND papf.effective_start_date <= TO_DATE(pay_payslip_report.get_parameter(ppa.legislative_parameters,'END_DATE'),'YYYY/MM/DD')

Line 104: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')

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