APPS.PA_FP_GEN_BUDGET_AMT_PUB dependencies on PA_WORK_TYPES_B

Line 1003: PA_WORK_TYPES_B WB,

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,
1007: PA_FORECAST_ITEMS FI

Line 2585: PA_WORK_TYPES_B WB

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:
2589: --dbms_output.put_line('From tmp4, l_proj_assgn_id_tab:'||l_proj_assgn_id_tab.count