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 2712: FROM pa_implementations_all impl

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

Line 6247: FROM pa_implementations_all impl

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

Line 8031: FROM pa_implementations_all impl

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