eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_PAYMENT_XML_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 23: FROM pay_assignment_actions paa

19: --
20: CURSOR c_payment_asg_actions
21: IS
22: SELECT 'TRANSFER_ACT_ID=P', paa.assignment_action_id
23: FROM pay_assignment_actions paa
24: WHERE paa.payroll_action_id =
25: pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
26: or paa.payroll_action_id = pay_magtape_generic.get_parameter_value
27: ('PAYROLL_ACTION_ID');

Line 33: pay_assignment_actions paa,

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
37: WHERE (ppa.payroll_action_id = pay_magtape_generic.get_parameter_value

Line 53: FROM pay_assignment_actions paa

49:
50: CURSOR c_bank_asg_actions
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

Line 57: ,pay_assignment_actions paa2

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')
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

Line 85: , pay_assignment_actions paa

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
88: , pay_payroll_actions ppa_chq
89: , pay_org_payment_methods_f popm

Line 86: , pay_assignment_actions paa_chq

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
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

Line 119: , pay_assignment_actions paa

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

Line 127: pay_assignment_actions paa2

123: and paa.object_type='HOU'
124: and ppp.organization_id=paa.object_id
125: and ppp.payroll_action_id= ppa.payroll_action_id
126: and exists (select 1 from pay_action_interlocks pai,
127: pay_assignment_actions paa2
128: where pai.locking_action_id=paa.assignment_action_id
129: and pai.locked_action_id=paa2.assignment_action_id
130: and paa2.payroll_action_id=ppa.payroll_action_id);
131: