APPS.HR_DE_ORG_INFO dependencies on DUAL

Line 19: FROM dual

15: --
16: CURSOR organization_hierarchy(p_org_id NUMBER, p_org_structure_version_id NUMBER, p_org_exists_in_hierarchy VARCHAR2) IS
17: SELECT p_org_id organization_id_parent
18: ,0 lev
19: FROM dual
20: WHERE p_org_exists_in_hierarchy = 'Y'
21: UNION
22: SELECT organization_id_parent
23: ,level lev

Line 34: FROM dual

30: --
31: CURSOR org_hierarchy(p_org_id NUMBER, p_org_structure_version_id NUMBER, p_org_exists_in_hierarchy VARCHAR2) IS
32: SELECT p_org_id organization_id_parent
33: ,0 lev
34: FROM dual
35: WHERE p_org_exists_in_hierarchy = 'Y'
36: UNION
37: SELECT organization_id_parent
38: ,level lev

Line 560: /* Wrapper Functions returning individual components of Location Address */

556: RETURN NULL;
557: -- ------------------------------------------------------------
558: END get_location;
559:
560: /* Wrapper Functions returning individual components of Location Address */
561: -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ --
562: FUNCTION get_addr_line1 (p_assignment_id in per_assignments_f.assignment_id%TYPE)
563: RETURN VARCHAR2 IS
564: l_line1 varchar2(240);

Line 709: FROM dual;

705: SELECT nvl(l_cc,' ')
706: ,nvl(l_e_bet,' ')
707: ,nvl(l_p_bet,' ')
708: INTO l_cc, l_e_bet, l_p_bet
709: FROM dual;
710:
711:
712:
713: l_all := l_cc || l_e_bet|| l_p_bet;