APPS.PJI_FM_CMT_EXTR dependencies on PA_PROJECTS_ALL

Line 96: PA_PROJECTS_ALL prj,

92: into
93: x_pa_period,
94: x_gl_period
95: from
96: PA_PROJECTS_ALL prj,
97: PA_PERIODS_ALL per
98: where
99: prj.PROJECT_ID = x_project_id and
100: nvl(per.ORG_ID, -1) = nvl(prj.ORG_ID, -1) and

Line 118: WHERE org_id = (select org_id from pa_projects_all where project_id = x_project_id);

114: BEGIN
115: SELECT decode( exp_cycle_start_day_code, 1, 8, exp_cycle_start_day_code )-1
116: into X_week_ending_day_index
117: FROM pa_implementations_all
118: WHERE org_id = (select org_id from pa_projects_all where project_id = x_project_id);
119:
120: select to_char(to_date('01-01-1950','DD-MM-YYYY') +X_week_ending_day_index-1, 'Day')
121: into X_week_ending_day from dual;
122:

Line 361: (l_project_id pa_projects_all.project_id%TYPE)

357: pct.project_id = x_project_id ;
358:
359:
360: CURSOR l_project_curr_code_csr
361: (l_project_id pa_projects_all.project_id%TYPE)
362: IS
363: SELECT project_currency_code,projfunc_currency_code
364: FROM pa_projects_all p
365: WHERE p.project_id = l_project_id;

Line 364: FROM pa_projects_all p

360: CURSOR l_project_curr_code_csr
361: (l_project_id pa_projects_all.project_id%TYPE)
362: IS
363: SELECT project_currency_code,projfunc_currency_code
364: FROM pa_projects_all p
365: WHERE p.project_id = l_project_id;
366:
367:
368: l_proj_curr_OK VARCHAR2(1) := 'Y';

Line 369: l_project_curr_code pa_projects_all.project_currency_code%TYPE := NULL;

365: WHERE p.project_id = l_project_id;
366:
367:
368: l_proj_curr_OK VARCHAR2(1) := 'Y';
369: l_project_curr_code pa_projects_all.project_currency_code%TYPE := NULL;
370:
371:
372: cmtrec selcmts%ROWTYPE;
373: row_processed NUMBER;

Line 393: l_PROJFUNC_CURR_CODE pa_projects_all.project_currency_code%TYPE := NULL;

389:
390: l_SYSTEM_LINKAGE pa_expenditure_items_all.SYSTEM_LINKAGE_FUNCTION%TYPE :=NULL;
391:
392:
393: l_PROJFUNC_CURR_CODE pa_projects_all.project_currency_code%TYPE := NULL;
394: l_PROJFUNC_COST_RATE_TYPE pa_commitment_txns.project_rate_type%TYPE := NULL;
395: l_PROJFUNC_COST_RATE_DATE DATE := NULL;
396: l_PROJFUNC_COST_EXCH_RATE NUMBER := NULL;
397:

Line 599: PA_PROJECTS_ALL prj

595: prj.SEGMENT1
596: into
597: l_from_project
598: from
599: PA_PROJECTS_ALL prj
600: where
601: prj.PROJECT_ID = PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
602: (PJI_FM_SUM_MAIN.g_process, 'FROM_PROJECT_ID');
603:

Line 619: PA_PROJECTS_ALL prj

615: prj.SEGMENT1
616: into
617: l_to_project
618: from
619: PA_PROJECTS_ALL prj
620: where
621: prj.PROJECT_ID = PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
622: (PJI_FM_SUM_MAIN.g_process, 'TO_PROJECT_ID');
623:

Line 663: PA_PROJECTS_ALL prj

659: prj.ROWID ROW_ID,
660: prj.ORG_ID ORG_ID, /*5377131*/
661: prj.PROJECT_STATUS_CODE
662: from
663: PA_PROJECTS_ALL prj
664: where
665: prj.ORG_ID = nvl(l_operating_unit,
666: prj.ORG_ID) and /*5377131*/
667: prj.SEGMENT1 between nvl(l_from_project, prj.SEGMENT1) and

Line 681: PA_PROJECTS_ALL prj

677: parallel_index(prj, PA_PROJECTS_N4) */
678: distinct
679: prj.PROJECT_STATUS_CODE
680: from
681: PA_PROJECTS_ALL prj
682: )
683: where
684: PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED
685: (PROJECT_STATUS_CODE, 'STATUS_REPORTING') = 'Y'

Line 845: from pa_projects_all

841:
842: commit;
843: -- bug 6847113
844: select org_id into l_org_id
845: from pa_projects_all
846: where project_id =
847: ( select project_id from PJI_FM_EXTR_DREVN
848: where BATCH_ID = l_helper_batch_id
849: and rownum=1);

Line 1538: PA_PROJECTS_ALL proj,

1534: tmp1.BOM_EQUIPMENT_RESOURCE_ID,
1535: tmp1.CBS_ELEMENT_ID /*Added for CBS Changes 16832862 */
1536: from
1537: PA_COMMITMENT_TXNS tmp1,
1538: PA_PROJECTS_ALL proj,
1539: PA_PROJECT_TYPES_ALL projtyp
1540: where
1541: tmp1.project_id = proj.project_id and
1542: proj.project_type = projtyp.project_type and