APPS.PA_EVENT_CORE dependencies on PA_AGREEMENTS_ALL

Line 1199: pa_agreements_all ag,

1195: CURSOR GET_AGREEMENT_ID
1196: IS
1197: SELECT AG.AGREEMENT_ID
1198: FROM pa_projects_all p,
1199: pa_agreements_all ag,
1200: hz_cust_accounts cust,
1201: Pa_summary_project_fundings fun
1202: WHERE p.project_id = P_project_id
1203: AND nvl(p.date_eff_funds_consumption, 'N') = 'Y'

Line 1263: FROM pa_agreements_all

1259:
1260: CURSOR get_agmt_date
1261: IS
1262: SELECT start_date, expiration_date
1263: FROM pa_agreements_all
1264: WHERE agreement_id = P_agreement_id;
1265:
1266: BEGIN
1267: