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.HRI_OPL_WMV dependencies on PAY_ASSIGNMENT_ACTIONS

Line 217: pay_assignment_actions_s.nextval next_seq

213: /* all employee assignments which either have been updated or had an ABV */
214: /* updated within the collection range */
215: CURSOR incr_action_csr IS
216: SELECT
217: pay_assignment_actions_s.nextval next_seq
218: ,assignment_id assignment_id
219: FROM
220: (SELECT DISTINCT
221: asg.assignment_id assignment_id

Line 246: INSERT INTO pay_assignment_actions

242: /* FULL REFRESH SECTION */
243: /************************/
244: IF (g_full_refresh = 'Y') THEN
245:
246: INSERT INTO pay_assignment_actions
247: (assignment_action_id,
248: assignment_id,
249: payroll_action_id,
250: action_status,

Line 258: pay_assignment_actions_s.nextval

254: object_version_number,
255: tax_unit_id,
256: source_action_id)
257: SELECT
258: pay_assignment_actions_s.nextval
259: ,assignment_id
260: ,pactid
261: ,'U'
262: ,chunk

Line 263: ,pay_assignment_actions_s.nextval

259: ,assignment_id
260: ,pactid
261: ,'U'
262: ,chunk
263: ,pay_assignment_actions_s.nextval
264: ,to_number(null)
265: ,1
266: ,to_number(null)
267: ,to_number(null)

Line 1197: FROM pay_assignment_actions paa

1193: /* Cursor to get the assignment_id for the assignment action */
1194: CURSOR asg_action_csr IS
1195: SELECT
1196: paa.assignment_id
1197: FROM pay_assignment_actions paa
1198: WHERE paa.assignment_action_id = p_assactid;
1199:
1200: /* Holds assignment from the cursor */
1201: l_assignment_id NUMBER;