APPS.PJI_FM_CMT_EXTR dependencies on PA_PROJECTS_ALL

Line 47: (l_project_id pa_projects_all.project_id%TYPE)

43: pct.project_id = x_project_id ;
44:
45:
46: CURSOR l_project_curr_code_csr
47: (l_project_id pa_projects_all.project_id%TYPE)
48: IS
49: SELECT project_currency_code,projfunc_currency_code
50: FROM pa_projects_all p
51: WHERE p.project_id = l_project_id;

Line 50: FROM pa_projects_all p

46: CURSOR l_project_curr_code_csr
47: (l_project_id pa_projects_all.project_id%TYPE)
48: IS
49: SELECT project_currency_code,projfunc_currency_code
50: FROM pa_projects_all p
51: WHERE p.project_id = l_project_id;
52:
53:
54: l_proj_curr_OK VARCHAR2(1) := 'Y';

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

51: WHERE p.project_id = l_project_id;
52:
53:
54: l_proj_curr_OK VARCHAR2(1) := 'Y';
55: l_project_curr_code pa_projects_all.project_currency_code%TYPE := NULL;
56:
57:
58: cmtrec selcmts%ROWTYPE;
59: row_processed NUMBER;

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

75:
76: l_SYSTEM_LINKAGE pa_expenditure_items_all.SYSTEM_LINKAGE_FUNCTION%TYPE :=NULL;
77:
78:
79: l_PROJFUNC_CURR_CODE pa_projects_all.project_currency_code%TYPE := NULL;
80: l_PROJFUNC_COST_RATE_TYPE pa_commitment_txns.project_rate_type%TYPE := NULL;
81: l_PROJFUNC_COST_RATE_DATE DATE := NULL;
82: l_PROJFUNC_COST_EXCH_RATE NUMBER := NULL;
83:

Line 282: PA_PROJECTS_ALL prj

278: prj.SEGMENT1
279: into
280: l_from_project
281: from
282: PA_PROJECTS_ALL prj
283: where
284: prj.PROJECT_ID = PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
285: (PJI_FM_SUM_MAIN.g_process, 'FROM_PROJECT_ID');
286:

Line 302: PA_PROJECTS_ALL prj

298: prj.SEGMENT1
299: into
300: l_to_project
301: from
302: PA_PROJECTS_ALL prj
303: where
304: prj.PROJECT_ID = PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
305: (PJI_FM_SUM_MAIN.g_process, 'TO_PROJECT_ID');
306:

Line 346: PA_PROJECTS_ALL prj

342: prj.ROWID ROW_ID,
343: prj.ORG_ID ORG_ID, /*5377131*/
344: prj.PROJECT_STATUS_CODE
345: from
346: PA_PROJECTS_ALL prj
347: where
348: prj.ORG_ID = nvl(l_operating_unit,
349: prj.ORG_ID) and /*5377131*/
350: prj.SEGMENT1 between nvl(l_from_project, prj.SEGMENT1) and

Line 364: PA_PROJECTS_ALL prj

360: parallel_index(prj, PA_PROJECTS_N4) */
361: distinct
362: prj.PROJECT_STATUS_CODE
363: from
364: PA_PROJECTS_ALL prj
365: )
366: where
367: PA_PROJECT_UTILS.CHECK_PRJ_STUS_ACTION_ALLOWED
368: (PROJECT_STATUS_CODE, 'STATUS_REPORTING') = 'Y'

Line 525: from pa_projects_all

521:
522: commit;
523: -- bug 6847113
524: select org_id into l_org_id
525: from pa_projects_all
526: where project_id =
527: ( select project_id from PJI_FM_EXTR_DREVN
528: where BATCH_ID = l_helper_batch_id
529: and rownum=1);

Line 1153: PA_PROJECTS_ALL proj,

1149: tmp1.BOM_LABOR_RESOURCE_ID,
1150: tmp1.BOM_EQUIPMENT_RESOURCE_ID
1151: from
1152: PA_COMMITMENT_TXNS tmp1,
1153: PA_PROJECTS_ALL proj,
1154: PA_PROJECT_TYPES_ALL projtyp
1155: where
1156: tmp1.project_id = proj.project_id and
1157: proj.project_type = projtyp.project_type and