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_SA_CHEQUE_REPORT dependencies on PAY_ACTION_INTERLOCKS

Line 73: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck

69: from pay_assignment_actions paa
70: where paa.payroll_action_id = p_pact_id
71: and paa.action_status = 'C'
72: and not exists ( select 1
73: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck
74: where lck.locked_action_id = paa.assignment_action_id
75: and lck.locking_action_id = paa1.assignment_action_id
76: and ppa1.payroll_action_id = paa1.payroll_action_id
77: and ppa1.action_type = 'D'

Line 91: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck

87: from pay_assignment_actions paa , per_all_assignments_f paf, hr_all_organization_units hou, per_all_people_f ppf
88: where paa.payroll_action_id = p_pact_id
89: and paa.action_status = 'C'
90: and not exists ( select 1
91: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck
92: where lck.locked_action_id = paa.assignment_action_id
93: and lck.locking_action_id = paa1.assignment_action_id
94: and ppa1.payroll_action_id = paa1.payroll_action_id
95: and ppa1.action_type = 'D'

Line 114: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck

110: from pay_assignment_actions paa , per_all_assignments_f paf, per_all_people_f ppf
111: where paa.payroll_action_id = p_pact_id
112: and paa.action_status = 'C'
113: and not exists ( select 1
114: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck
115: where lck.locked_action_id = paa.assignment_action_id
116: and lck.locking_action_id = paa1.assignment_action_id
117: and ppa1.payroll_action_id = paa1.payroll_action_id
118: and ppa1.action_type = 'D'

Line 136: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck

132: per_all_people_f ppf, per_all_assignments_f paf
133: where paa.payroll_action_id = p_pact_id
134: and paa.action_status = 'C'
135: and not exists ( select 1
136: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck
137: where lck.locked_action_id = paa.assignment_action_id
138: and lck.locking_action_id = paa1.assignment_action_id
139: and ppa1.payroll_action_id = paa1.payroll_action_id
140: and ppa1.action_type = 'D'

Line 172: from pay_pre_payments ppp,pay_action_interlocks lck , pay_org_payment_methods_f org ,

168: FROM pay_pre_payments_v2 pv2
169: WHERE pv2.business_group_id+0 = p_business_group_id
170: AND pv2.assignment_action_id = l_assact_id
171: AND pv2.pre_payment_id in (select ppp.pre_payment_id
172: from pay_pre_payments ppp,pay_action_interlocks lck , pay_org_payment_methods_f org ,
173: pay_payment_types pt,pay_assignment_actions paa1
174: where lck.locking_action_id = l_assact_id
175: and lck.locked_action_id = ppp.assignment_action_id
176: and paa1.assignment_action_id = lck.locking_action_id