APPS.PJI_FM_EXTR dependencies on PA_AGREEMENTS_ALL

Line 59: ,pa_agreements_all agr

55: ,pf.rowid ROW_ID
56: ,ceil(ROWNUM / PJI_FM_SUM_MAIN.g_commit_threshold) BATCH_ID
57: FROM pji_fm_proj_batch_map bat
58: ,pa_project_fundings pf
59: ,pa_agreements_all agr
60: ,pa_project_customers cust
61: WHERE l_extraction_type = 'FULL'
62: AND pf.agreement_id = agr.agreement_id
63: AND pf.project_id = bat.project_id

Line 91: ,pa_agreements_all agr

87: ,pf.rowid ROW_ID
88: ,ceil(ROWNUM / PJI_FM_SUM_MAIN.g_commit_threshold) BATCH_ID
89: FROM pji_fm_proj_batch_map bat
90: ,pa_project_fundings pf
91: ,pa_agreements_all agr
92: ,pa_project_customers cust
93: WHERE l_extraction_type = 'INCREMENTAL'
94: AND pf.agreement_id = agr.agreement_id
95: AND pf.project_id = bat.project_id

Line 122: ,pa_agreements_all agr

118: ,pf.rowid ROW_ID
119: ,ceil(ROWNUM / PJI_FM_SUM_MAIN.g_commit_threshold) BATCH_ID
120: FROM pji_fm_proj_batch_map bat
121: ,pa_project_fundings pf
122: ,pa_agreements_all agr
123: ,pa_project_customers cust
124: WHERE l_extraction_type = 'INCREMENTAL'
125: AND pf.agreement_id = agr.agreement_id
126: AND pf.project_id = bat.project_id

Line 156: ,pa_agreements_all agr

152: ,pf.rowid ROW_ID
153: ,ceil(ROWNUM / PJI_FM_SUM_MAIN.g_commit_threshold) BATCH_ID
154: FROM pji_fm_proj_batch_map bat
155: ,pa_project_fundings pf
156: ,pa_agreements_all agr
157: ,pa_project_customers cust
158: WHERE l_extraction_type = 'PARTIAL'
159: AND pf.agreement_id = agr.agreement_id
160: AND pf.project_id = bat.project_id

Line 448: , pa_agreements_all agr

444: , ceil(ROWNUM / PJI_FM_SUM_MAIN.g_commit_threshold) batch_id
445: FROM
446: pji_fm_proj_batch_map bat
447: , pa_draft_revenues_all drv
448: , pa_agreements_all agr
449: WHERE
450: l_extraction_type = 'FULL'
451: and bat.worker_id = p_worker_id
452: and bat.project_id = drv.project_id

Line 489: , pa_agreements_all agr

485: , ceil(ROWNUM / PJI_FM_SUM_MAIN.g_commit_threshold) batch_id
486: FROM
487: pji_fm_proj_batch_map bat
488: , pa_draft_revenues_all drv
489: , pa_agreements_all agr
490: WHERE
491: l_extraction_type = 'INCREMENTAL'
492: and bat.worker_id = p_worker_id
493: and bat.project_id = drv.project_id

Line 527: , pa_agreements_all agr

523: , ceil(ROWNUM / PJI_FM_SUM_MAIN.g_commit_threshold) batch_id
524: FROM
525: pji_fm_proj_batch_map bat
526: , pa_draft_revenues_all drv
527: , pa_agreements_all agr
528: WHERE
529: l_extraction_type = 'INCREMENTAL'
530: and bat.worker_id = p_worker_id
531: and bat.project_id = drv.project_id

Line 566: , pa_agreements_all agr

562: , ceil(ROWNUM / PJI_FM_SUM_MAIN.g_commit_threshold) batch_id
563: FROM
564: pji_fm_proj_batch_map bat
565: , pa_draft_revenues_all drv
566: , pa_agreements_all agr
567: WHERE
568: l_extraction_type = 'PARTIAL'
569: and bat.worker_id = p_worker_id
570: and bat.project_id = drv.project_id

Line 607: , pa_agreements_all agr

603: , ceil(ROWNUM / PJI_FM_SUM_MAIN.g_commit_threshold) batch_id
604: FROM
605: pa_pji_proj_events_log log
606: , pji_fm_proj_batch_map bat
607: , pa_agreements_all agr
608: /* Note:
609: * The tables below are not needed if Billing Team
610: * populates the PA and GL period_names while
611: * inserting records into the log table

Line 1271: , pa_agreements_all ag

1267: , to_number(null) AS QUANTITY
1268: , to_number(null) AS BILL_QUANTITY
1269: , -1 AS CBS_ELEMENT_ID /* Added for CBS Changes */
1270: From PJI_FM_EXTR_DREVN drev
1271: , pa_agreements_all ag
1272: , pa_project_customers cust
1273: , pa_cust_rev_dist_lines_all crdl
1274: Where 1 = 1
1275: And drev.worker_id = p_worker_id

Line 1504: From pa_agreements_all ag

1500: , to_number(null) AS EOU_UBR
1501: , to_number(null) AS EOU_UER
1502: , to_number(null) AS QUANTITY
1503: , to_number(null) AS BILL_QUANTITY
1504: From pa_agreements_all ag
1505: , pa_project_customers cust
1506: , pa_events ev
1507: , pa_event_types evt
1508: , PJI_FM_EXTR_DREVN drev

Line 1741: , pa_agreements_all ag

1737: , cust.bill_another_project_flag
1738: , cust.customer_id
1739: FROM
1740: PJI_FM_EXTR_DREVN drev
1741: , pa_agreements_all ag
1742: , pa_project_customers cust
1743: , pa_cust_rev_dist_lines_all crdl
1744: WHERE
1745: drev.worker_id = p_worker_id

Line 1835: , pa_agreements_all ag

1831: , drev.gl_date gl_date
1832: , drev.gl_period_name gl_period_name
1833: FROM
1834: PJI_FM_EXTR_DREVN drev
1835: , pa_agreements_all ag
1836: , pa_project_customers cust
1837: , pa_cust_event_rdl_all erdl /* Changed the order for bug 8668173 */
1838: , pa_events ev
1839: , pa_event_types evt

Line 2943: , pa_agreements_all agr

2939: pji_fm_proj_batch_map bat
2940: , pa_projects_all ppa
2941: , pa_project_types_all ptyp
2942: , pa_draft_invoices_all dinv
2943: , pa_agreements_all agr
2944: WHERE
2945: l_extraction_type = 'FULL'
2946: and bat.worker_id = p_worker_id
2947: and ppa.project_id = bat.project_id

Line 3006: , pa_agreements_all agr

3002: pji_fm_proj_batch_map bat
3003: , pa_draft_invoices_all dinv
3004: , pa_projects_all ppa
3005: , pa_project_types_all ptyp
3006: , pa_agreements_all agr
3007: WHERE
3008: l_extraction_type = 'INCREMENTAL'
3009: and bat.worker_id = p_worker_id
3010: and bat.project_id = dinv.project_id

Line 3069: , pa_agreements_all agr

3065: pji_fm_proj_batch_map bat
3066: , pa_draft_invoices_all dinv
3067: , pa_projects_all ppa
3068: , pa_project_types_all ptyp
3069: , pa_agreements_all agr
3070: WHERE
3071: l_extraction_type = 'INCREMENTAL'
3072: and bat.worker_id = p_worker_id
3073: and ppa.project_id = bat.project_id

Line 3134: , pa_agreements_all agr

3130: pji_fm_proj_batch_map bat
3131: , pa_projects_all ppa
3132: , pa_project_types_all ptyp
3133: , pa_draft_invoices_all dinv
3134: , pa_agreements_all agr
3135: WHERE
3136: l_extraction_type = 'PARTIAL'
3137: and bat.worker_id = p_worker_id
3138: and ppa.project_id = bat.project_id