APPS.PA_FP_GEN_BUDGET_AMT_PUB dependencies on PA_PROJECT_ASSIGNMENTS

Line 1002: FROM PA_PROJECT_ASSIGNMENTS PA,

998: RTA.PERSON_ID,
999: PA.ASSIGNMENT_NAME,
1000: FI.EXPENDITURE_ORGANIZATION_ID,
1001: DECODE(PA.EXPENDITURE_TYPE,null,NULL,'EXPENDITURE_TYPE')
1002: FROM PA_PROJECT_ASSIGNMENTS PA,
1003: PA_WORK_TYPES_B WB,
1004: PA_PROJECT_ROLE_TYPES PR,
1005: PA_PROJECTS_ALL P,
1006: PA_RESOURCE_TXN_ATTRIBUTES RTA,

Line 1417: FROM pa_project_assignments

1413: CURSOR CHECK_BILL_RATE_OVRD_EXISTS IS
1414: SELECT 'Y'
1415: FROM DUAL
1416: WHERE EXISTS (SELECT assignment_id
1417: FROM pa_project_assignments
1418: WHERE project_id = p_project_id
1419: AND bill_rate_override is not null);
1420:
1421: l_bill_rate_ovrd_exists_flag VARCHAR2(1) := 'N';

Line 2584: PA_PROJECT_ASSIGNMENTS PA,

2580: l_proj_bill_rate_override_tab, -- M-Closeout ER: Bill Rate Override ER
2581: l_proj_bill_rate_cur_ovrd_tab, -- M-Closeout ER: Bill Rate Override ER
2582: l_proj_billable_flag -- M-Closeout ER: Honor billability flag ER
2583: FROM PA_RES_LIST_MAP_TMP4 tmp4,
2584: PA_PROJECT_ASSIGNMENTS PA,
2585: PA_WORK_TYPES_B WB
2586: WHERE tmp4.txn_source_id = pa.assignment_id
2587: AND WB.WORK_TYPE_ID = PA.WORK_TYPE_ID(+);
2588: