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 2713: , pa_projects_all proj

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

Line 2760: FROM pa_projects_all

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

Line 6232: FROM pa_projects_all

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

Line 6248: , pa_projects_all proj

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

Line 8032: , pa_projects_all proj

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

Line 8055: FROM pa_projects_all

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