APPS.PAY_FR_PAY_FILE dependencies on PAY_MAGTAPE_GENERIC

Line 37: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');

33: ppa.org_payment_method_id,
34: 'BUSINESS_GROUP_ID=C', ppa.business_group_id
35: from pay_payroll_actions ppa
36: where ppa.payroll_action_id =
37: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
38:
39:
40: /********************************************************
41: * Cursor to fetch body record information *

Line 57: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

53: pay_pre_payments ppp,
54: pay_assignment_actions paa,
55: pay_payroll_actions ppa
56: where paa.payroll_action_id =
57: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
58: and paa.pre_payment_id = ppp.pre_payment_id
59: and paa.payroll_action_id = ppa.payroll_action_id
60: and paa.assignment_id = pa.assignment_id
61: and pa.person_id = per.person_id

Line 64: order by decode(pay_magtape_generic.get_parameter_value('SET_ORDER_BY'),

60: and paa.assignment_id = pa.assignment_id
61: and pa.person_id = per.person_id
62: and ppa.effective_date between pa.effective_start_date and pa.effective_end_date
63: and ppa.effective_date between per.effective_start_date and per.effective_end_date
64: order by decode(pay_magtape_generic.get_parameter_value('SET_ORDER_BY'),
65: 'NAME', per.order_name,
66: 'NUMBER', per.employee_number, null);
67:
68: FUNCTION get_payers_id (p_opm_id in number,