APPS.PAY_NO_PAYSLIP_ARCHIVE dependencies on DUAL

Line 839: p_sql := 'select 1 from dual where to_char(:payroll_action_id) = dummy';

835:
836: EXCEPTION
837: WHEN OTHERS THEN
838: -- Return cursor that selects no rows
839: p_sql := 'select 1 from dual where to_char(:payroll_action_id) = dummy';
840:
841: END RANGE_CODE;
842:
843: ---------------------------------- PROCEDURE ASSIGNMENT_ACTION_CODE ----------------------------------------------------------------

Line 969: FROM dual;

965: IF l_prepay_action_id <> rec_prepaid_assignments.prepaid_action_id THEN
966:
967: SELECT pay_assignment_actions_s.NEXTVAL
968: INTO l_actid
969: FROM dual;
970: --
971: g_index_assact := g_index_assact + 1;
972: g_lock_table(g_index_assact).archive_assact_id := l_actid; /* For Element archival */
973:

Line 3053: and rownum=1)) from dual;

3049: (select eei_information1 from pay_element_type_extra_info petei
3050: where petei.information_type='NO_ELEMENT_CODES'
3051: and element_type_id = p_ele_type_id
3052: and eei_information2 is null
3053: and rownum=1)) from dual;
3054:
3055: --------------------------------------------------------
3056:
3057: /* cursor to get the further element entry info for payslip information */

Line 4326: and rownum=1)) from dual;

4322: (select eei_information1 from pay_element_type_extra_info petei
4323: where petei.information_type='NO_ELEMENT_CODES'
4324: and element_type_id = p_ele_type_id
4325: and eei_information2 is null
4326: and rownum=1)) from dual;
4327:
4328: --------------------------------------------------------
4329:
4330: /* cursor to get the further element entry info for payslip information */