APPS.PA_AGREEMENT_PUB dependencies on PA_AGREEMENTS_ALL

Line 2039: FROM pa_agreements_all a

2035:
2036: CURSOR l_limit_flag_csr(p_agreement_id NUMBER)
2037: IS
2038: SELECT a.revenue_limit_flag,a.invoice_limit_flag
2039: FROM pa_agreements_all a
2040: WHERE a.agreement_id = p_agreement_id;
2041:
2042: /*CURSOR l_amounts_csr(p_agreement_id NUMBER)
2043: IS

Line 2359: -- select amount into l_nik from pa_agreements_all where agreement_id = p_agreement_id;

2355: END IF;
2356: p_return_status := FND_API.G_RET_STS_ERROR;
2357: RAISE FND_API.G_EXC_ERROR;
2358: -- ELSE
2359: -- select amount into l_nik from pa_agreements_all where agreement_id = p_agreement_id;
2360: END IF;
2361:
2362: -- Agreement Id
2363: IF (p_agreement_id IS NULL)

Line 2418: FROM pa_agreements_all a

2414:
2415: -- VALIDATE THE INCOMING PARAMETERS
2416: SELECT a. customer_id
2417: INTO l_customer_id
2418: FROM pa_agreements_all a
2419: WHERE a.agreement_id = p_agreement_id;
2420: IF pa_agreement_pvt.check_add_funding_ok
2421: (p_project_id => p_pa_project_id
2422: ,p_task_id => p_pa_task_id

Line 3177: FROM pa_agreements_all a

3173:
3174: CURSOR l_limit_flag_csr(p_agreement_id NUMBER)
3175: IS
3176: SELECT revenue_limit_flag,invoice_limit_flag
3177: FROM pa_agreements_all a
3178: WHERE a.agreement_id = p_agreement_id;
3179:
3180: /*CURSOR l_amounts_csr(p_agreement_id NUMBER)
3181: IS

Line 5261: FROM pa_agreements_all a

5257: -- CHECK IF IT IS OK TO ADD FUNDING
5258:
5259: SELECT a. customer_id
5260: INTO l_customer_id
5261: FROM pa_agreements_all a
5262: WHERE a.agreement_id = p_agreement_id;
5263:
5264: p_add_funding_ok_flag := pa_agreement_pvt.check_add_funding_ok
5265: (p_project_id => p_project_id