APPS.PA_FP_GEN_BUDGET_AMT_PUB dependencies on PA_WORK_TYPES_B

Line 991: PA_WORK_TYPES_B WB,

987: PA.ASSIGNMENT_NAME,
988: FI.EXPENDITURE_ORGANIZATION_ID,
989: DECODE(PA.EXPENDITURE_TYPE,null,NULL,'EXPENDITURE_TYPE')
990: FROM PA_PROJECT_ASSIGNMENTS PA,
991: PA_WORK_TYPES_B WB,
992: PA_PROJECT_ROLE_TYPES PR,
993: PA_PROJECTS_ALL P,
994: PA_RESOURCE_TXN_ATTRIBUTES RTA,
995: PA_FORECAST_ITEMS FI

Line 2573: PA_WORK_TYPES_B WB

2569: l_proj_bill_rate_cur_ovrd_tab, -- M-Closeout ER: Bill Rate Override ER
2570: l_proj_billable_flag -- M-Closeout ER: Honor billability flag ER
2571: FROM PA_RES_LIST_MAP_TMP4 tmp4,
2572: PA_PROJECT_ASSIGNMENTS PA,
2573: PA_WORK_TYPES_B WB
2574: WHERE tmp4.txn_source_id = pa.assignment_id
2575: AND WB.WORK_TYPE_ID = PA.WORK_TYPE_ID(+);
2576:
2577: --dbms_output.put_line('From tmp4, l_proj_assgn_id_tab:'||l_proj_assgn_id_tab.count