APPS.PA_AGREEMENT_PUB dependencies on PA_AGREEMENTS_ALL

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

2323: END IF;
2324: p_return_status := FND_API.G_RET_STS_ERROR;
2325: RAISE FND_API.G_EXC_ERROR;
2326: -- ELSE
2327: -- select amount into l_nik from pa_agreements_all where agreement_id = p_agreement_id;
2328: END IF;
2329:
2330: -- Agreement Id
2331: IF (p_agreement_id IS NULL)

Line 2355: FROM pa_agreements_all a

2351:
2352: -- VALIDATE THE INCOMING PARAMETERS
2353: SELECT a. customer_id
2354: INTO l_customer_id
2355: FROM pa_agreements_all a
2356: WHERE a.agreement_id = p_agreement_id;
2357: IF pa_agreement_pvt.check_add_funding_ok
2358: (p_project_id => p_pa_project_id
2359: ,p_task_id => p_pa_task_id

Line 5127: FROM pa_agreements_all a

5123: -- CHECK IF IT IS OK TO ADD FUNDING
5124:
5125: SELECT a. customer_id
5126: INTO l_customer_id
5127: FROM pa_agreements_all a
5128: WHERE a.agreement_id = p_agreement_id;
5129:
5130: p_add_funding_ok_flag := pa_agreement_pvt.check_add_funding_ok
5131: (p_project_id => p_project_id