APPS.PAY_GB_PAYSLIP_ARCHIVE dependencies on DUAL

Line 1344: FROM dual;

1340: SELECT decode(g_element_table(l_index).uom, 'M',
1341: ltrim(rtrim(to_char(fnd_number.canonical_to_number(rec_element_value.result_value), '999999999999999990.00'))),
1342: rec_element_value.result_value)
1343: INTO l_result_value
1344: FROM dual;
1345: --
1346: pay_action_information_api.create_action_information (
1347: p_action_information_id => l_action_info_id
1348: , p_action_context_id => p_action_context_id

Line 1925: FROM dual;

1921: IF l_prepay_action_id <> csr_rec.prepaid_action_id THEN
1922: --
1923: SELECT pay_assignment_actions_s.NEXTVAL
1924: INTO l_actid
1925: FROM dual;
1926: --
1927: -- Create the archive assignment action for master action
1928: --
1929: hr_nonrun_asact.insact(l_actid,csr_rec.assignment_id,pactid,chunk,NULL);

Line 1962: FROM dual;

1958: THEN
1959:
1960: SELECT pay_assignment_actions_s.NEXTVAL
1961: INTO l_actid
1962: FROM dual;
1963:
1964: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
1965:
1966: hr_nonrun_asact.insact(l_actid,csr_rec.assignment_id,pactid,chunk,NULL);

Line 2167: FROM dual;

2163: LOOP
2164: -- create additional archive assignment actions and interlocks
2165: SELECT pay_assignment_actions_s.NEXTVAL
2166: INTO l_actid
2167: FROM dual;
2168:
2169: hr_utility.set_location('csr_child_rec.run_type = ' ||
2170: csr_child_rec.run_type,30);
2171: hr_utility.set_location('csr_rec.master_assignment_action_id = ' ||