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 3042: and rownum=1)) from dual;

3038: (select eei_information1 from pay_element_type_extra_info petei
3039: where petei.information_type='NO_ELEMENT_CODES'
3040: and element_type_id = p_ele_type_id
3041: and eei_information2 is null
3042: and rownum=1)) from dual;
3043:
3044: --------------------------------------------------------
3045:
3046: /* cursor to get the further element entry info for payslip information */

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

4311: (select eei_information1 from pay_element_type_extra_info petei
4312: where petei.information_type='NO_ELEMENT_CODES'
4313: and element_type_id = p_ele_type_id
4314: and eei_information2 is null
4315: and rownum=1)) from dual;
4316:
4317: --------------------------------------------------------
4318:
4319: /* cursor to get the further element entry info for payslip information */