APPS.PA_JOB dependencies on PA_IMPLEMENTATIONS_ALL

Line 120: from pa_implementations_all imp,

116: into job_delete_allowed
117: from sys.dual
118: where not exists (
119: select null
120: from pa_implementations_all imp,
121: per_jobs job
122: where job.job_id = p_job_id
123: and job.business_group_id = imp.business_group_id );
124: Other_Business_group := 'Y';

Line 142: , pa_implementations_all imp

138: dummy VARCHAR2(240); -- used for into argument
139: cursor pa_job_exists is
140: SELECT 'The Job may not be deleted if PA is installed and implemented'
141: FROM fnd_product_installations fpi
142: , pa_implementations_all imp
143: WHERE fpi.application_id = 275
144: AND fpi.status = 'I';
145:
146: BEGIN