APPS.PA_RES_MANAGEMENT_AMG_PUB dependencies on PA_IMPLEMENTATIONS_ALL

Line 429: FROM pa_implementations_all impl

425: WHERE project_role_id = c_role_id ;
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:

Line 2713: FROM pa_implementations_all impl

2709:
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:

Line 6248: FROM pa_implementations_all impl

6244: WHERE project_role_id = c_role_id ;
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:

Line 8033: FROM pa_implementations_all impl

8029: AND primary_subteam_flag = 'Y';
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: