APPS.PA_AGREEMENT_PVT dependencies on PA_AGREEMENTS_ALL

Line 39: FROM pa_agreements_all

35: IS
36: CURSOR l_agreement_id_csr
37: IS
38: SELECT 'X'
39: FROM pa_agreements_all
40: where agreement_id = p_af_agreement_id;
41:
42: l_api_name CONSTANT VARCHAR2(30) := 'Convert_ag_ref_to_id';
43: l_agreement_id NUMBER ;

Line 279: FROM pa_agreements_all p

275: RETURN NUMBER
276: IS
277: CURSOR c_agreements_csr IS
278: SELECT p.agreement_id
279: FROM pa_agreements_all p
280: WHERE p.pm_agreement_reference = p_pm_agreement_reference;
281:
282: l_agreement_rec c_agreements_csr%ROWTYPE;
283:

Line 824: CURSOR agrcur IS SELECT * FROM PA_AGREEMENTS_ALL WHERE AGREEMENT_ID = p_agreement_id;

820:
821: l_RETURN VARCHAR2(1) :='Y';
822:
823: /* Cursor added for bug 6602451 */
824: CURSOR agrcur IS SELECT * FROM PA_AGREEMENTS_ALL WHERE AGREEMENT_ID = p_agreement_id;
825:
826: BEGIN
827: --dbms_output.put_line('Inside: PA_AGREEMENT_PVT.CHECK_UPDATE_AGREEMENT_OK');
828: FOR l_agrcur IN agrcur LOOP /*Bug 6602451 */

Line 1053: FROM pa_agreements_all

1049: cur_end_date,
1050: cur_adv_req,
1051: cur_adv_amt,
1052: cur_agmt_amt
1053: FROM pa_agreements_all
1054: WHERE agreement_id = p_agreement_id;
1055: /* Commented for bug 6853994
1056: SELECT sum(allocated_amount)
1057: INTO l_tot_fund

Line 1317: FROM PA_AGREEMENTS_ALL

1313: ) ='Y' THEN
1314: IF l_return = 'Y' THEN
1315: BEGIN
1316: SELECT 'N' INTO l_return
1317: FROM PA_AGREEMENTS_ALL
1318: WHERE AGREEMENT_ID = p_agreement_id
1319: AND (AGREEMENT_CURRENCY_CODE <> p_agreement_currency_code
1320: AND EXISTS ( SELECT *
1321: FROM PA_PROJECT_FUNDINGS

Line 1500: FROM pa_agreements_all

1496:
1497: /*Federal */
1498: SELECT count(*)
1499: INTO l_count
1500: FROM pa_agreements_all
1501: WHERE agreement_id = p_agreement_id
1502: and advance_amount >0;
1503:
1504:

Line 2775: FROM pa_agreements_all a

2771:
2772: /*Federal*/
2773: SELECT decode(a.advance_required,'Y',nvl(a.advance_amount,0),nvl(a.amount,0))
2774: INTO l_agr_amt
2775: FROM pa_agreements_all a
2776: WHERE a.agreement_id = p_agreement_id;
2777: --dbms_output.put_line('INSIDE: => validate_funding_amt => Total Agreement Amt is '|| to_char(l_agr_amt));
2778:
2779: SELECT nvl(SUM(f.allocated_amount),0)