DBA Data[Home] [Help]

APPS.PAY_ES_TWR_CALC_PKG dependencies on DUAL

Line 665: FROM DUAL

661: --
662: CURSOR csr_chk_twr_process(c_assignment_id NUMBER
663: ,c_effective_date DATE) IS
664: SELECT 'Y'
665: FROM DUAL
666: WHERE EXISTS(SELECT 1
667: FROM pay_element_entries_f pee
668: ,pay_element_types_f pet
669: WHERE pee.assignment_id = c_assignment_id

Line 841: FROM dual

837: ,peffective_date IN DATE) RETURN VARCHAR2 IS
838: --
839: CURSOR csr_chk_new_emp (c_assignment_id number)IS
840: SELECT 'N'
841: FROM dual
842: WHERE EXISTS(SELECT NULL
843: FROM pay_assignment_actions paa
844: ,pay_payroll_actions ppa
845: ,pay_run_results prr

Line 1731: SELECT userenv('LANGUAGE') INTO g_nls_db_char FROM dual;

1727: BEGIN
1728: --
1729: hr_utility.set_location('Entered Procedure clob to blob',120);
1730: --
1731: SELECT userenv('LANGUAGE') INTO g_nls_db_char FROM dual;
1732: --
1733: l_buffer_len := 20000;
1734: l_length_clob := dbms_lob.getlength(p_clob);
1735: l_offset := 1;