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 8273: SELECT pay_assignment_actions_s.NEXTVAL

8269: FETCH c_chk_asg_action INTO l_action_id;
8270: CLOSE c_chk_asg_action;
8271: IF (l_action_id IS NULL)
8272: THEN
8273: SELECT pay_assignment_actions_s.NEXTVAL
8274: INTO l_action_id
8275: FROM dual;
8276:
8277: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 11);

Line 8309: SELECT pay_assignment_actions_s.NEXTVAL

8305: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 11);
8306:
8307: IF (l_action_id IS NULL)
8308: THEN
8309: SELECT pay_assignment_actions_s.NEXTVAL
8310: INTO l_action_id
8311: FROM dual;
8312:
8313: pay_in_utils.set_location(g_debug,'Inserting Assignment Actions as it was null', 14);

Line 8361: SELECT pay_assignment_actions_s.NEXTVAL

8357: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 11);
8358:
8359: IF (l_action_id IS NULL)
8360: THEN
8361: SELECT pay_assignment_actions_s.NEXTVAL
8362: INTO l_action_id
8363: FROM dual;
8364:
8365: pay_in_utils.set_location(g_debug,'Inserting Assignment Actions as it was null', 14);

Line 8896: SELECT pay_assignment_actions_s.NEXTVAL

8892: pay_in_utils.trace('l_dummy in g_count_sal_delete ',l_dummy);
8893:
8894: IF (l_dummy IS NULL)
8895: THEN
8896: SELECT pay_assignment_actions_s.NEXTVAL
8897: INTO l_action_id
8898: FROM dual;
8899:
8900: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);

Line 9045: SELECT pay_assignment_actions_s.NEXTVAL

9041: pay_in_utils.trace('l_dummy in g_count_sal_addition ',l_dummy);
9042:
9043: IF (l_dummy IS NULL)
9044: THEN
9045: SELECT pay_assignment_actions_s.NEXTVAL
9046: INTO l_action_id
9047: FROM dual;
9048:
9049: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);

Line 9196: SELECT pay_assignment_actions_s.NEXTVAL

9192: pay_in_utils.trace('l_dummy in g_count_sal_update ',l_dummy);
9193:
9194: IF (l_dummy IS NULL)
9195: THEN
9196: SELECT pay_assignment_actions_s.NEXTVAL
9197: INTO l_action_id
9198: FROM dual;
9199:
9200: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);

Line 9359: SELECT pay_assignment_actions_s.NEXTVAL

9355: CLOSE c_chk_asg_action;
9356:
9357: IF (l_dummy IS NULL)
9358: THEN
9359: SELECT pay_assignment_actions_s.NEXTVAL
9360: INTO l_action_id
9361: FROM dual;
9362:
9363: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);

Line 9435: SELECT pay_assignment_actions_s.NEXTVAL

9431:
9432: pay_in_utils.set_location(g_debug,'Value of l_dummy is '|| l_dummy, 61);
9433: IF (l_dummy IS NULL)
9434: THEN
9435: SELECT pay_assignment_actions_s.NEXTVAL
9436: INTO l_action_id
9437: FROM dual;
9438:
9439: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);

Line 9515: SELECT pay_assignment_actions_s.NEXTVAL

9511:
9512: pay_in_utils.set_location(g_debug,'Value of dummy is ' || l_dummy ,3);
9513: IF (l_dummy IS NULL)
9514: THEN
9515: SELECT pay_assignment_actions_s.NEXTVAL
9516: INTO l_action_id
9517: FROM dual;
9518:
9519: pay_in_utils.set_location(g_debug,'Value of l_action_id is '|| l_action_id, 61);