APPS.PERFRPHR dependencies on DUAL

Line 61: from dual;

57: utl_raw.cast_to_varchar2(hextoraw('C592')),'OE'
58: ),
59: utl_raw.cast_to_varchar2(hextoraw('C386')),'AE'
60: )
61: from dual;
62:
63: begin
64:
65: open c_uppercase(p_input_string);

Line 100: FROM DUAL

96: AND hr1.org_information_context = 'FR_ESTAB_INFO'
97: AND p_ent_id IS NOT NULL
98: UNION
99: SELECT NVL(p_est_id,0)
100: FROM DUAL
101: WHERE p_ent_id IS NULL)
102: AND NVL(peo.sex,'X') = NVL(p_sex,NVL(peo.sex,'X'))
103: AND asg.person_id = peo.person_id
104: AND ((ast.per_system_status = 'ACTIVE_ASSIGN' AND p_include_suspended = 'N') OR

Line 134: FROM DUAL

130: AND hr1.org_information_context = 'FR_ESTAB_INFO'
131: AND p_ent_id IS NOT NULL
132: UNION
133: SELECT NVL(p_est_id,0)
134: FROM DUAL
135: WHERE p_ent_id IS NULL)
136: AND NVL(peo2.sex,'X') = NVL(p_sex,NVL(peo2.sex,'X'))
137: AND asg2.person_id = peo.person_id
138: AND asg2.person_id = peo2.person_id