DBA Data[Home] [Help]

APPS.PAY_DIRECT_DEPOSIT_XML dependencies on PAY_MAGTAPE_GENERIC

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

48: fnd_date.date_to_canonical(ppa.effective_date),
49: 'TRANSFER_ORG_PAY_METHOD=P',ppa.org_payment_method_id
50: from pay_payroll_actions ppa
51: where ppa.payroll_action_id =
52: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID');
53: --and ppa.payroll_action_id = paa.payroll_action_id
54: --group by tax_unit_id,ppa.payroll_action_id, ppa.effective_date,
55: --ppa.org_payment_method_id;
56:

Line 68: WHERE paa.payroll_action_id = pay_magtape_generic.get_parameter_value(

64: 'TRANSFER_PREPAY_ASG_ACT=P',ppp.assignment_action_id,
65: 'DEPOSIT_AMOUNT=P', ppp.value
66: FROM pay_assignment_actions paa
67: ,pay_pre_payments ppp
68: WHERE paa.payroll_action_id = pay_magtape_generic.get_parameter_value(
69: 'PAYROLL_ACTION_ID')
70: and paa.pre_payment_id = ppp.pre_payment_id;
71:
72: CURSOR c_get_asg_action IS

Line 74: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')

70: and paa.pre_payment_id = ppp.pre_payment_id;
71:
72: CURSOR c_get_asg_action IS
73: SELECT 'TRANSFER_ACT_ID=P',
74: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
75: FROM DUAL;
76:
77:
78: PROCEDURE get_headers ;