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_IN_24QC_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 7894: SELECT pay_assignment_actions_s.NEXTVAL

7890: FETCH c_chk_asg_action INTO l_action_id;
7891: CLOSE c_chk_asg_action;
7892: IF (l_action_id IS NULL)
7893: THEN
7894: SELECT pay_assignment_actions_s.NEXTVAL
7895: INTO l_action_id
7896: FROM dual;
7897:
7898: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 11);

Line 7930: SELECT pay_assignment_actions_s.NEXTVAL

7926: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 11);
7927:
7928: IF (l_action_id IS NULL)
7929: THEN
7930: SELECT pay_assignment_actions_s.NEXTVAL
7931: INTO l_action_id
7932: FROM dual;
7933:
7934: pay_in_utils.set_location(g_debug,'Inserting Assignment Actions as it was null', 14);

Line 7982: SELECT pay_assignment_actions_s.NEXTVAL

7978: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 11);
7979:
7980: IF (l_action_id IS NULL)
7981: THEN
7982: SELECT pay_assignment_actions_s.NEXTVAL
7983: INTO l_action_id
7984: FROM dual;
7985:
7986: pay_in_utils.set_location(g_debug,'Inserting Assignment Actions as it was null', 14);

Line 8494: SELECT pay_assignment_actions_s.NEXTVAL

8490: pay_in_utils.trace('l_dummy in g_count_sal_delete ',l_dummy);
8491:
8492: IF (l_dummy IS NULL)
8493: THEN
8494: SELECT pay_assignment_actions_s.NEXTVAL
8495: INTO l_action_id
8496: FROM dual;
8497:
8498: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);

Line 8643: SELECT pay_assignment_actions_s.NEXTVAL

8639: pay_in_utils.trace('l_dummy in g_count_sal_addition ',l_dummy);
8640:
8641: IF (l_dummy IS NULL)
8642: THEN
8643: SELECT pay_assignment_actions_s.NEXTVAL
8644: INTO l_action_id
8645: FROM dual;
8646:
8647: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);

Line 8794: SELECT pay_assignment_actions_s.NEXTVAL

8790: pay_in_utils.trace('l_dummy in g_count_sal_update ',l_dummy);
8791:
8792: IF (l_dummy IS NULL)
8793: THEN
8794: SELECT pay_assignment_actions_s.NEXTVAL
8795: INTO l_action_id
8796: FROM dual;
8797:
8798: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);

Line 8957: SELECT pay_assignment_actions_s.NEXTVAL

8953: CLOSE c_chk_asg_action;
8954:
8955: IF (l_dummy IS NULL)
8956: THEN
8957: SELECT pay_assignment_actions_s.NEXTVAL
8958: INTO l_action_id
8959: FROM dual;
8960:
8961: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);

Line 9033: SELECT pay_assignment_actions_s.NEXTVAL

9029:
9030: pay_in_utils.set_location(g_debug,'Value of l_dummy is '|| l_dummy, 61);
9031: IF (l_dummy IS NULL)
9032: THEN
9033: SELECT pay_assignment_actions_s.NEXTVAL
9034: INTO l_action_id
9035: FROM dual;
9036:
9037: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);

Line 9113: SELECT pay_assignment_actions_s.NEXTVAL

9109:
9110: pay_in_utils.set_location(g_debug,'Value of dummy is ' || l_dummy ,3);
9111: IF (l_dummy IS NULL)
9112: THEN
9113: SELECT pay_assignment_actions_s.NEXTVAL
9114: INTO l_action_id
9115: FROM dual;
9116:
9117: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);