APPS.PA_IND_RATE_SCH_REVISIONS_PKG dependencies on PA_COST_DISTRIBUTION_LINES_ALL

Line 254: (SELECT NULL FROM pa_cost_distribution_lines_all CDL

250: select 1 from dual where exists (
251: select 1 from pa_ind_compiled_sets ICS
252: WHERE ics.ind_rate_sch_revision_id = x_ind_rate_sch_revision_id and
253: (exists
254: (SELECT NULL FROM pa_cost_distribution_lines_all CDL
255: WHERE ICS.ind_compiled_set_id = CDL.ind_compiled_set_id
256: )
257: OR (l_gms_installed = 'Y' and EXISTS
258: (SELECT NULL FROM gms_award_distributions adl

Line 273: (SELECT NULL FROM pa_cost_distribution_lines_all CDL

269:
270: cursor c4 (l_ind_compile_set_id number ) is
271: select 1 from dual where exists
272:
273: (SELECT NULL FROM pa_cost_distribution_lines_all CDL
274: WHERE CDL.ind_compiled_set_id = l_ind_compile_set_id
275: )
276: /* OR (l_gms_installed = 'Y' and EXISTS*/ /* for bug 6334295 */
277: OR EXISTS