APPS.PA_ORG dependencies on DUAL

Line 76: FROM sys.dual

72:
73: /* Replacing the above SELECT with the below SELECT statement. */
74: SELECT 'X'
75: INTO dummy1
76: FROM sys.dual
77: WHERE exists (
78: SELECT 'X'
79: FROM pa_ind_rate_sch_revisions ind
80: WHERE ind.organization_structure_id = p_org_structure_id

Line 150: FROM sys.dual

146:
147: /* Replacing the above SELECT with the below SELECT statement. */
148: SELECT 'X'
149: INTO dummy1
150: FROM sys.dual
151: WHERE exists (
152: SELECT 'X'
153: FROM pa_ind_rate_sch_revisions ind
154: WHERE ind.org_structure_version_id = p_org_structure_version_id

Line 232: FROM sys.dual

228: We should not be looking at the hierarchy attached at the
229: Business group.
230: SELECT 'X'
231: INTO dummy1
232: FROM sys.dual
233: WHERE p_org_structure_element_id IN (
234: SELECT org_structure_element_id
235: FROM hr_organization_information info,
236: per_org_structure_elements ose

Line 249: FROM sys.dual

245: -- hr_utility.trace('before check');
246: -- hr_utility.trace('before check p_org_structure_element_id IS ' || p_org_structure_element_id);
247: SELECT 'X'
248: INTO dummy1
249: FROM sys.dual
250: WHERE exists (
251: SELECT ics.organization_id
252: FROM pa_ind_compiled_sets ics,/*10327103 changed the table used from "pa_ind_cost_multipliers" to pa_ind_compiled_sets*/
253: pa_ind_rate_sch_revisions irr, --Bug 6074710