APPS.PA_FUNDING_CORE dependencies on PA_AGREEMENTS

Line 191: FROM pa_agreements

187: IF (l_return_status ='Y') THEN
188:
189: SELECT count(*)
190: INTO l_count
191: FROM pa_agreements
192: WHERE agreement_id = p_agreement_id
193: AND advance_amount >0;
194:
195: IF (l_count >0) THEN

Line 588: FROM PA_PROJECTS_ALL P, PA_AGREEMENTS_ALL A

584: BEGIN
585: --dbms_output.put_line('Inside: PA_FUNDING_CORE.CHECK_PROJ_AGR_FUND_OK');
586: SELECT 'Y'
587: INTO Is_agr_fund_ok
588: FROM PA_PROJECTS_ALL P, PA_AGREEMENTS_ALL A
589: WHERE P.PROJECT_ID = p_project_id
590: AND A.AGREEMENT_ID = p_agreement_id
591: AND (P.multi_currency_billing_flag = 'Y'
592: OR (p.multi_currency_billing_flag = 'N'