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_JP_BALANCE_VIEW_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 177: from pay_assignment_actions paa,

173: to_char(paa.assignment_action_id)
174: )
175: , 24))
176: into l_assignment_action_id
177: from pay_assignment_actions paa,
178: pay_payroll_actions ppa
179: where paa.assignment_id = p_assignment_id
180: and paa.action_status = 'C'
181: and ppa.payroll_action_id = paa.payroll_action_id

Line 194: from pay_assignment_actions paa,

190: to_char(paa.assignment_action_id)
191: )
192: , 16))
193: into l_assignment_action_id
194: from pay_assignment_actions paa,
195: pay_payroll_actions ppa
196: where paa.assignment_id = p_assignment_id
197: and paa.action_status = 'C'
198: and ppa.payroll_action_id = paa.payroll_action_id

Line 228: pay_assignment_actions paa,

224: between asg.effective_start_date and asg.effective_end_date
225: and asg2.person_id = asg.person_id
226: group by asg2.assignment_id
227: ) v,
228: pay_assignment_actions paa,
229: pay_payroll_actions ppa
230: where paa.assignment_id = v.assignment_id
231: and paa.action_status = 'C'
232: and ppa.payroll_action_id = paa.payroll_action_id

Line 255: pay_assignment_actions paa,

251: between asg.effective_start_date and asg.effective_end_date
252: and asg2.person_id = asg.person_id
253: group by asg2.assignment_id
254: ) v,
255: pay_assignment_actions paa,
256: pay_payroll_actions ppa
257: where paa.assignment_id = v.assignment_id
258: and paa.action_status = 'C'
259: and ppa.payroll_action_id = paa.payroll_action_id

Line 305: from pay_assignment_actions paa,

301: to_char(paa.assignment_action_id)
302: )
303: , 16))
304: into l_assignment_action_id
305: from pay_assignment_actions paa,
306: pay_payroll_actions ppa
307: where paa.assignment_id = p_assignment_id
308: and paa.action_status = 'C'
309: and ppa.payroll_action_id = paa.payroll_action_id

Line 336: pay_assignment_actions paa,

332: between asg.effective_start_date and asg.effective_end_date
333: and asg2.person_id = asg.person_id
334: group by asg2.assignment_id
335: ) v,
336: pay_assignment_actions paa,
337: pay_payroll_actions ppa
338: where paa.assignment_id = v.assignment_id
339: and paa.action_status = 'C'
340: and ppa.payroll_action_id = paa.payroll_action_id