DBA Data[Home] [Help]

APPS.PJI_FM_CMT_EXTR dependencies on PJI_FM_EXTR_DREVN

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

626: end;
627:
628: end if;
629:
630: insert into PJI_FM_EXTR_DREVN -- overload of draft revenues table for cmt
631: (
632: WORKER_ID,
633: ROW_ID,
634: LINE_SOURCE_TYPE,

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

718: BATCH_ID,
719: null,
720: null
721: from
722: PJI_FM_EXTR_DREVN; -- overload of draft revenues table for commitments
723:
724: delete
725: from PA_COMMITMENT_TXNS
726: where PROJECT_ID in

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

727: (
728: select
729: PROJECT_ID
730: from
731: PJI_FM_EXTR_DREVN -- overload of draft revenues table for cmt
732: );
733:
734: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,
735: 'PJI_FM_CMT_EXTR.REFRESH_PROJPERF_CMT_PRE(p_worker_id);');

Line 847: ( select project_id from PJI_FM_EXTR_DREVN

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

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

858: x_err_stage,
859: x_err_code);
860:
861: for c in (select PROJECT_ID
862: from PJI_FM_EXTR_DREVN -- overload of drev table for cmt
863: where BATCH_ID = l_helper_batch_id) loop
864:
865: begin
866:

Line 1044: 'PJI_FM_EXTR_DREVN',

1040:
1041: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
1042:
1043: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
1044: 'PJI_FM_EXTR_DREVN',
1045: 'NORMAL',
1046: null);
1047:
1048: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,