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

Line 106: , pay_action_interlocks pail

102: Cursor get_alternate_date_earned (p_assignment_id NUMBER) IS
103: SELECT max(nvl(ppa.date_earned,ppar.date_earned))
104: FROM pay_payroll_actions ppa
105: , pay_assignment_actions paa
106: , pay_action_interlocks pail
107: , pay_payroll_actions ppar
108: , pay_assignment_actions paar
109: WHERE paa.assignment_id = p_assignment_id
110: AND paa.payroll_action_id = ppa.payroll_action_id

Line 145: , pay_action_interlocks pai

141: CURSOR get_ass_action_id(p_assignment_id NUMBER) IS
142: SELECT ppp.assignment_action_id
143: FROM pay_payroll_actions ppa
144: , pay_assignment_actions paa
145: , pay_action_interlocks pai
146: , pay_pre_payments ppp
147: WHERE paa.assignment_id = p_assignment_id
148: AND paa.payroll_action_id = ppa.payroll_action_id
149: AND ppa.action_type = 'M'

Line 197: , pay_action_interlocks pai

193: CURSOR get_context(p_assignment_id NUMBER) IS
194: SELECT ppa.date_earned
195: FROM pay_payroll_actions ppa
196: , pay_assignment_actions paa
197: , pay_action_interlocks pai
198: WHERE paa.assignment_id = p_assignment_id
199: AND paa.payroll_action_id = ppa.payroll_action_id
200: AND ppa.action_type = 'M'
201: AND pai.locking_action_id = paa.assignment_action_id