APPS.PER_KW_XDO_REPORT dependencies on DUAL

Line 37: FROM DUAL)

33: START WITH pose.organization_id_parent = nvl(p_legal_employer, l_parent_id)
34: AND pose.org_structure_version_id = p_org_structure_version_id
35: UNION
36: SELECT nvl(p_legal_employer, l_parent_id)
37: FROM DUAL)
38: AND p_org_structure_version_id IS NOT NULL
39: AND (p_legal_employer IS NOT NULL OR l_parent_id IS NOT NULL)
40: AND org.organization_id = hoi.organization_id
41: AND hoi.org_information_context = 'CLASS'

Line 132: FROM DUAL;

128: IF p_date IS NOT NULL THEN
129: BEGIN
130: SELECT fnd_date.canonical_to_date(p_date)
131: INTO l_date
132: FROM DUAL;
133: EXCEPTION
134: WHEN OTHERS THEN
135: l_date := TRUNC(sysdate);
136: END;

Line 546: FROM DUAL)

542: START WITH pose.organization_id_parent = nvl(p_legal_employer, l_parent_id)
543: AND pose.org_structure_version_id = p_org_structure_version_id
544: UNION
545: SELECT nvl(p_legal_employer, l_parent_id)
546: FROM DUAL)
547: AND p_org_structure_version_id IS NOT NULL
548: AND (p_legal_employer IS NOT NULL OR l_parent_id IS NOT NULL)
549: AND org.organization_id = hoi.organization_id
550: AND hoi.org_information_context = 'CLASS'

Line 629: FROM DUAL;

625: IF p_date IS NOT NULL THEN
626: BEGIN
627: SELECT fnd_date.canonical_to_date(p_date)
628: INTO l_date
629: FROM DUAL;
630: EXCEPTION
631: WHEN OTHERS THEN
632: l_date := TRUNC(sysdate);
633: END;

Line 1036: select userenv('LANGUAGE') into g_nls_db_char from dual;

1032: l_blob_offset pls_integer := 1;
1033:
1034: begin
1035: hr_utility.set_location('Entered Procedure clob to blob',120);
1036: select userenv('LANGUAGE') into g_nls_db_char from dual;
1037: l_length_clob := dbms_lob.getlength(p_clob);
1038: l_offset := 1;
1039: while l_length_clob > 0 loop
1040: hr_utility.trace('l_length_clob '|| l_length_clob);