APPS.PA_RES_MANAGEMENT_AMG_PUB dependencies on PA_PROJECTS_ALL

Line 20: FROM pa_projects_all

16: BEGIN
17:
18: SELECT start_date
19: INTO l_start_dt
20: FROM pa_projects_all
21: WHERE project_id = l_prj_id;
22:
23: RETURN l_start_dt;
24:

Line 42: FROM pa_projects_all

38: BEGIN
39:
40: SELECT completion_date
41: INTO l_compl_dt
42: FROM pa_projects_all
43: WHERE project_id = l_prj_id;
44:
45: RETURN l_compl_dt;
46:

Line 414: FROM pa_projects_all

410: AND lookup_code <> 'RESOURCE';
411:
412: CURSOR c_get_project_dtls(c_project_id NUMBER) IS
413: SELECT role_list_id, multi_currency_billing_flag, calendar_id, work_type_id, location_id
414: FROM pa_projects_all
415: WHERE project_id = c_project_id;
416:
417: CURSOR c_get_team_templ_dtls(c_team_templ_id NUMBER) IS
418: SELECT role_list_id, calendar_id, work_type_id

Line 430: , pa_projects_all proj

426:
427: CURSOR get_bill_rate_override_flags(c_project_id NUMBER) IS
428: SELECT impl.rate_discount_reason_flag ,impl.br_override_flag, impl.br_discount_override_flag
429: FROM pa_implementations_all impl
430: , pa_projects_all proj
431: WHERE proj.org_id=impl.org_id -- Removed nvl condition from org_id : Post review changes for Bug 5130421
432: AND proj.project_id = c_project_id ;
433:
434: CURSOR c_get_lookup_exists(c_lookup_type VARCHAR2, c_lookup_code VARCHAR2) IS

Line 2714: , pa_projects_all proj

2710:
2711: CURSOR get_bill_rate_override_flags(c_project_id NUMBER) IS
2712: SELECT impl.rate_discount_reason_flag ,impl.br_override_flag, impl.br_discount_override_flag
2713: FROM pa_implementations_all impl
2714: , pa_projects_all proj
2715: WHERE proj.org_id=impl.org_id -- Removed nvl condition from org_id : Post review changes for Bug 5130421
2716: AND proj.project_id = c_project_id ;
2717:
2718: CURSOR c_get_lookup_exists(c_lookup_type VARCHAR2, c_lookup_code VARCHAR2) IS

Line 2761: FROM pa_projects_all

2757:
2758: -- 5144288, 5144369 : Added c_get_mcb_flag
2759: CURSOR c_get_mcb_flag(c_project_id NUMBER) IS
2760: SELECT multi_currency_billing_flag
2761: FROM pa_projects_all
2762: WHERE project_id = c_project_id;
2763:
2764:
2765: l_req_dtls_csr c_get_requirement_details%ROWTYPE;

Line 6233: FROM pa_projects_all

6229: AND lookup_code <> 'RESOURCE';
6230:
6231: CURSOR c_get_project_dtls(c_project_id NUMBER) IS
6232: SELECT role_list_id, multi_currency_billing_flag, calendar_id, work_type_id, location_id
6233: FROM pa_projects_all
6234: WHERE project_id = c_project_id;
6235:
6236: CURSOR c_get_team_templ_dtls(c_team_templ_id NUMBER) IS
6237: SELECT role_list_id, calendar_id, work_type_id

Line 6249: , pa_projects_all proj

6245:
6246: CURSOR get_bill_rate_override_flags(c_project_id NUMBER) IS
6247: SELECT impl.rate_discount_reason_flag ,impl.br_override_flag, impl.br_discount_override_flag
6248: FROM pa_implementations_all impl
6249: , pa_projects_all proj
6250: WHERE proj.org_id=impl.org_id -- Removed nvl condition from org_id : Post review changes for Bug 5130421
6251: AND proj.project_id = c_project_id ;
6252:
6253: CURSOR c_get_lookup_exists(c_lookup_type VARCHAR2, c_lookup_code VARCHAR2) IS

Line 8034: , pa_projects_all proj

8030:
8031: CURSOR get_bill_rate_override_flags(c_project_id NUMBER) IS
8032: SELECT impl.rate_discount_reason_flag ,impl.br_override_flag, impl.br_discount_override_flag
8033: FROM pa_implementations_all impl
8034: , pa_projects_all proj
8035: WHERE proj.org_id=impl.org_id -- Removed nvl condition from org_id : Post review changes for Bug 5130421
8036: AND proj.project_id = c_project_id ;
8037:
8038: CURSOR c_get_lookup_exists(c_lookup_type VARCHAR2, c_lookup_code VARCHAR2) IS

Line 8057: FROM pa_projects_all

8053:
8054: -- 5144288, 5144369 : Added c_get_mcb_flag
8055: CURSOR c_get_mcb_flag(c_project_id NUMBER) IS
8056: SELECT multi_currency_billing_flag
8057: FROM pa_projects_all
8058: WHERE project_id = c_project_id;
8059:
8060:
8061: