DBA Data[Home] [Help]

APPS.PA_ASSIGNMENTS_PUB dependencies on PA_IMPLEMENTATIONS_ALL

Line 3304: FROM PA_IMPLEMENTATIONS_ALL impl,pa_projects_all proj

3300: l_req_rdisc_reason VARCHAR2(1);
3301: --MOAC changes Bug 4363092: removed nvl with org_id
3302: Cursor bil_rate_oride_imple(p_project_id number) is
3303: SELECT impl.RATE_DISCOUNT_REASON_FLAG,impl.BR_OVERRIDE_FLAG,impl.BR_DISCOUNT_OVERRIDE_FLAG
3304: FROM PA_IMPLEMENTATIONS_ALL impl,pa_projects_all proj
3305: WHERE proj.org_id=impl.org_id
3306: and proj.project_id = p_project_id ;
3307: /*Code addition for bug 3096132 ends*/
3308:

Line 4477: FROM PA_IMPLEMENTATIONS_ALL impl

4473: CURSOR get_bill_rate_override_flags IS
4474: SELECT impl.RATE_DISCOUNT_REASON_FLAG
4475: ,impl.BR_OVERRIDE_FLAG
4476: ,impl.BR_DISCOUNT_OVERRIDE_FLAG
4477: FROM PA_IMPLEMENTATIONS_ALL impl
4478: ,pa_projects_all proj
4479: WHERE proj.org_id=impl.org_id
4480: and proj.project_id = l_assignment_rec.project_id ;
4481: