DBA Data[Home] [Help]

APPS.PJI_FM_CMT_EXTR dependencies on PJI_FM_EXTR_DREVN

Line 313: insert into PJI_FM_EXTR_DREVN -- overload of draft revenues table for cmt

309: end;
310:
311: end if;
312:
313: insert into PJI_FM_EXTR_DREVN -- overload of draft revenues table for cmt
314: (
315: WORKER_ID,
316: ROW_ID,
317: LINE_SOURCE_TYPE,

Line 405: PJI_FM_EXTR_DREVN; -- overload of draft revenues table for commitments

401: BATCH_ID,
402: null,
403: null
404: from
405: PJI_FM_EXTR_DREVN; -- overload of draft revenues table for commitments
406:
407: delete
408: from PA_COMMITMENT_TXNS
409: where PROJECT_ID in

Line 414: PJI_FM_EXTR_DREVN -- overload of draft revenues table for cmt

410: (
411: select
412: PROJECT_ID
413: from
414: PJI_FM_EXTR_DREVN -- overload of draft revenues table for cmt
415: );
416:
417: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
418: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT_PRE(p_worker_id);');

Line 527: ( select project_id from PJI_FM_EXTR_DREVN

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);
530: PA_CURRENCY.G_org_id := l_org_id;
531:

Line 542: from PJI_FM_EXTR_DREVN -- overload of drev table for cmt

538: x_err_stage,
539: x_err_code);
540:
541: for c in (select PROJECT_ID
542: from PJI_FM_EXTR_DREVN -- overload of drev table for cmt
543: where BATCH_ID = l_helper_batch_id) loop
544:
545: begin
546:

Line 663: 'PJI_FM_EXTR_DREVN',

659:
660: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
661:
662: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
663: 'PJI_FM_EXTR_DREVN',
664: 'NORMAL',
665: null);
666:
667: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,