APPS.PA_FP_GEN_BUDGET_AMT_PUB dependencies on PA_PROJECT_ASSIGNMENTS

Line 990: FROM PA_PROJECT_ASSIGNMENTS PA,

986: RTA.PERSON_ID,
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,

Line 1405: FROM pa_project_assignments

1401: CURSOR CHECK_BILL_RATE_OVRD_EXISTS IS
1402: SELECT 'Y'
1403: FROM DUAL
1404: WHERE EXISTS (SELECT assignment_id
1405: FROM pa_project_assignments
1406: WHERE project_id = p_project_id
1407: AND bill_rate_override is not null);
1408:
1409: l_bill_rate_ovrd_exists_flag VARCHAR2(1) := 'N';

Line 2572: PA_PROJECT_ASSIGNMENTS PA,

2568: l_proj_bill_rate_override_tab, -- M-Closeout ER: Bill Rate Override ER
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: