APPS.PA_EVENT_CORE dependencies on PA_AGREEMENTS_ALL

Line 1178: pa_agreements_all ag,

1174: CURSOR GET_AGREEMENT_ID
1175: IS
1176: SELECT AG.AGREEMENT_ID
1177: FROM pa_projects_all p,
1178: pa_agreements_all ag,
1179: hz_cust_accounts cust,
1180: Pa_summary_project_fundings fun
1181: WHERE p.project_id = P_project_id
1182: AND nvl(p.date_eff_funds_consumption, 'N') = 'Y'

Line 1242: FROM pa_agreements_all

1238:
1239: CURSOR get_agmt_date
1240: IS
1241: SELECT start_date, expiration_date
1242: FROM pa_agreements_all
1243: WHERE agreement_id = P_agreement_id;
1244:
1245: BEGIN
1246: