[Home] [Help]
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
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
237: We should not be looking at the hierarchy attached at the
238: Business group.
239: SELECT 'X'
240: INTO dummy1
241: FROM sys.dual
242: WHERE p_org_structure_element_id IN (
243: SELECT org_structure_element_id
244: FROM hr_organization_information info,
245: per_org_structure_elements ose
254: -- hr_utility.trace('before check');
255: -- hr_utility.trace('before check p_org_structure_element_id IS ' || p_org_structure_element_id);
256: SELECT 'X'
257: INTO dummy1
258: FROM sys.dual
259: WHERE exists (
260: SELECT icm.organization_id
261: FROM pa_ind_cost_multipliers icm,
262: per_org_structure_elements ose