DBA Data[Home] [Help]

APPS.PAY_PAYMENT_XML_PKG dependencies on PAY_PRE_PAYMENTS

Line 34: pay_pre_payments ppp,

30: IS
31: SELECT distinct 'EXT_ACT_ID=P', popm.external_account_id
32: FROM pay_payroll_actions ppa,
33: pay_assignment_actions paa,
34: pay_pre_payments ppp,
35: pay_action_interlocks pai,
36: pay_org_payment_methods_f popm
37: WHERE (ppa.payroll_action_id = pay_magtape_generic.get_parameter_value
38: ('TRANSFER_PAYROLL_ACTION_ID')

Line 55: ,pay_pre_payments ppp

51: IS
52: SELECT 'TRANSFER_ACT_ID=P', paa.assignment_action_id
53: FROM pay_assignment_actions paa
54: ,pay_action_interlocks pai
55: ,pay_pre_payments ppp
56: ,pay_org_payment_methods_f popm
57: ,pay_assignment_actions paa2
58: ,pay_payroll_actions ppa
59: WHERE (paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

Line 83: FROM pay_pre_payments ppp

79: 'ASG_ID=P', paa.assignment_id,
80: 'ORG_ID=P',paa.object_id, --should be null
81: 'PRE_PAY_EFF_DATE=P', ppa.effective_date,
82: 'DET_BG_ID=P', ppa.business_group_id
83: FROM pay_pre_payments ppp
84: , pay_action_interlocks pai
85: , pay_assignment_actions paa
86: , pay_assignment_actions paa_chq
87: , pay_payroll_actions ppa

Line 118: FROM pay_pre_payments ppp

114: 'ASG_ID=P', paa.assignment_id, --null
115: 'ORG_ID=P',paa.object_id,
116: 'PRE_PAY_EFF_DATE=P', ppa.effective_date,
117: 'DET_BG_ID=P', ppa.business_group_id
118: FROM pay_pre_payments ppp
119: , pay_assignment_actions paa
120: , pay_payroll_actions ppa
121: WHERE paa.assignment_action_id= pay_magtape_generic.get_parameter_value
122: ('TRANSFER_ACT_ID')