APPS.PAY_PAYMENT_XML_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 14: from pay_payroll_actions ppa

10: CURSOR c_header_footer
11: IS
12: SELECT 'PAYROLL_ACTION_ID=C', ppa.payroll_action_id,
13: 'BG_ID=P', ppa.business_group_id
14: from pay_payroll_actions ppa
15: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value
16: ('TRANSFER_PAYROLL_ACTION_ID')
17: or ppa.payroll_action_id = pay_magtape_generic.get_parameter_value
18: ('PAYROLL_ACTION_ID');

Line 32: FROM pay_payroll_actions ppa,

28:
29: CURSOR c_bank_act_grp
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

Line 58: ,pay_payroll_actions ppa

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')
60: or paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'))
61: and paa.assignment_action_id=pai.locking_action_id
62: and pai.locked_action_id=ppp.assignment_action_id

Line 87: , pay_payroll_actions ppa

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
88: , pay_payroll_actions ppa_chq
89: , pay_org_payment_methods_f popm
90: WHERE paa_chq.assignment_action_id = pay_magtape_generic.get_parameter_value
91: ('TRANSFER_ACT_ID')

Line 88: , pay_payroll_actions ppa_chq

84: , pay_action_interlocks pai
85: , pay_assignment_actions paa
86: , pay_assignment_actions paa_chq
87: , pay_payroll_actions ppa
88: , pay_payroll_actions ppa_chq
89: , pay_org_payment_methods_f popm
90: WHERE paa_chq.assignment_action_id = pay_magtape_generic.get_parameter_value
91: ('TRANSFER_ACT_ID')
92: and paa_chq.assignment_action_id = pai.locking_action_id

Line 120: , pay_payroll_actions ppa

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')
123: and paa.object_type='HOU'
124: and ppp.organization_id=paa.object_id