APPS.PA_ASSIGNMENTS_PUB dependencies on PA_IMPLEMENTATIONS_ALL

Line 3221: FROM PA_IMPLEMENTATIONS_ALL impl,pa_projects_all proj

3217: l_req_rdisc_reason VARCHAR2(1);
3218: --MOAC changes Bug 4363092: removed nvl with org_id
3219: Cursor bil_rate_oride_imple(p_project_id number) is
3220: SELECT impl.RATE_DISCOUNT_REASON_FLAG,impl.BR_OVERRIDE_FLAG,impl.BR_DISCOUNT_OVERRIDE_FLAG
3221: FROM PA_IMPLEMENTATIONS_ALL impl,pa_projects_all proj
3222: WHERE proj.org_id=impl.org_id
3223: and proj.project_id = p_project_id ;
3224: /*Code addition for bug 3096132 ends*/
3225:

Line 3549: FROM PA_IMPLEMENTATIONS_ALL impl

3545: CURSOR get_bill_rate_override_flags IS
3546: SELECT impl.RATE_DISCOUNT_REASON_FLAG
3547: ,impl.BR_OVERRIDE_FLAG
3548: ,impl.BR_DISCOUNT_OVERRIDE_FLAG
3549: FROM PA_IMPLEMENTATIONS_ALL impl
3550: ,pa_projects_all proj
3551: WHERE proj.org_id=impl.org_id
3552: and proj.project_id = l_assignment_rec.project_id ;
3553: