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_GB_PAYSLIP_ARCHIVE dependencies on DUAL

Line 1410: FROM dual;

1406: SELECT decode(g_element_table(l_index).uom, 'M',
1407: ltrim(rtrim(to_char(fnd_number.canonical_to_number(rec_element_value.result_value), '999999999999999990.00'))),
1408: rec_element_value.result_value)
1409: INTO l_result_value
1410: FROM dual;
1411: --
1412: pay_action_information_api.create_action_information (
1413: p_action_information_id => l_action_info_id
1414: , p_action_context_id => p_action_context_id

Line 1996: FROM dual;

1992: IF l_prepay_action_id <> csr_rec.prepaid_action_id THEN
1993: --
1994: SELECT pay_assignment_actions_s.NEXTVAL
1995: INTO l_actid
1996: FROM dual;
1997: --
1998: -- Create the archive assignment action for master action
1999: --
2000: hr_nonrun_asact.insact(l_actid,csr_rec.assignment_id,pactid,chunk,NULL);

Line 2033: FROM dual;

2029: THEN
2030:
2031: SELECT pay_assignment_actions_s.NEXTVAL
2032: INTO l_actid
2033: FROM dual;
2034:
2035: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
2036:
2037: hr_nonrun_asact.insact(l_actid,csr_rec.assignment_id,pactid,chunk,NULL);

Line 2240: FROM dual;

2236: LOOP
2237: -- create additional archive assignment actions and interlocks
2238: SELECT pay_assignment_actions_s.NEXTVAL
2239: INTO l_actid
2240: FROM dual;
2241:
2242: hr_utility.set_location('csr_child_rec.run_type = ' ||
2243: csr_child_rec.run_type,30);
2244: hr_utility.set_location('csr_rec.master_assignment_action_id = ' ||