APPS.PA_XLA_UPGRADE dependencies on PA_XLA_UPG_EVENTS_GT

Line 547: INTO PA_XLA_UPG_EVENTS_GT

543: l_user,
544: l_pa_app_id,
545: l_request_id
546: )
547: INTO PA_XLA_UPG_EVENTS_GT
548: (expenditure_item_id,
549: event_id,
550: grouped_line_type,
551: event_date,

Line 759: PA_XLA_UPG_EVENTS_GT event_gt

755: lines_gt.reference_3,
756: lines_gt.ledger_id,
757: lines_gt.gl_date
758: from PA_XLA_UPG_LINES_GT lines_gt,
759: PA_XLA_UPG_EVENTS_GT event_gt
760: where event_gt.expenditure_item_id = lines_gt.expenditure_item_id
761: and event_gt.event_date = lines_gt.gl_date
762: and event_gt.grouped_line_type = lines_gt.grouped_line_type
763: );

Line 771: SET cdl.acct_event_id = (select /*+ INDEX(event_gt, PA_XLA_UPG_EVENTS_GT_N1) */

767:
768:
769: UPDATE /*+ INDEX(cdl, PA_COST_DISTRIBUTION_LINES_U1) */
770: pa_cost_distribution_lines_all cdl
771: SET cdl.acct_event_id = (select /*+ INDEX(event_gt, PA_XLA_UPG_EVENTS_GT_N1) */
772: event_gt.event_id from PA_XLA_UPG_EVENTS_GT event_gt
773: where cdl.expenditure_item_id = event_gt.expenditure_item_id
774: and cdl.gl_date = event_gt.event_date
775: and decode(cdl.line_type, 'R', 'R', 'B' ) = event_gt.grouped_line_type

Line 772: event_gt.event_id from PA_XLA_UPG_EVENTS_GT event_gt

768:
769: UPDATE /*+ INDEX(cdl, PA_COST_DISTRIBUTION_LINES_U1) */
770: pa_cost_distribution_lines_all cdl
771: SET cdl.acct_event_id = (select /*+ INDEX(event_gt, PA_XLA_UPG_EVENTS_GT_N1) */
772: event_gt.event_id from PA_XLA_UPG_EVENTS_GT event_gt
773: where cdl.expenditure_item_id = event_gt.expenditure_item_id
774: and cdl.gl_date = event_gt.event_date
775: and decode(cdl.line_type, 'R', 'R', 'B' ) = event_gt.grouped_line_type
776: and rownum = 1)

Line 790: SET cdl.acct_event_id = (select /*+ INDEX(event_gt, PA_XLA_UPG_EVENTS_GT_N1) */

786:
787:
788: UPDATE /*+ INDEX(cdl, PA_CC_DIST_LINES_U2) */
789: PA_CC_DIST_LINES_ALL cdl
790: SET cdl.acct_event_id = (select /*+ INDEX(event_gt, PA_XLA_UPG_EVENTS_GT_N1) */
791: event_gt.event_id from PA_XLA_UPG_EVENTS_GT event_gt
792: where cdl.expenditure_item_id = event_gt.expenditure_item_id
793: and cdl.gl_date = event_gt.event_date
794: and cdl.line_type = event_gt.grouped_line_type

Line 791: event_gt.event_id from PA_XLA_UPG_EVENTS_GT event_gt

787:
788: UPDATE /*+ INDEX(cdl, PA_CC_DIST_LINES_U2) */
789: PA_CC_DIST_LINES_ALL cdl
790: SET cdl.acct_event_id = (select /*+ INDEX(event_gt, PA_XLA_UPG_EVENTS_GT_N1) */
791: event_gt.event_id from PA_XLA_UPG_EVENTS_GT event_gt
792: where cdl.expenditure_item_id = event_gt.expenditure_item_id
793: and cdl.gl_date = event_gt.event_date
794: and cdl.line_type = event_gt.grouped_line_type
795: and rownum = 1)

Line 1237: INTO PA_XLA_UPG_EVENTS_GT

1233: l_user,
1234: l_pa_app_id,
1235: l_request_id
1236: )
1237: INTO PA_XLA_UPG_EVENTS_GT
1238: (expenditure_item_id,
1239: event_id,
1240: grouped_line_type,
1241: event_date,

Line 1456: PA_XLA_UPG_EVENTS_GT event_gt

1452: lines_gt.reference_3,
1453: lines_gt.ledger_id,
1454: lines_gt.gl_date
1455: from PA_XLA_UPG_LINES_GT lines_gt,
1456: PA_XLA_UPG_EVENTS_GT event_gt
1457: where event_gt.expenditure_item_id = lines_gt.expenditure_item_id
1458: and event_gt.event_date = lines_gt.gl_date
1459: and event_gt.ledger_id = lines_gt.ledger_id /* Added for bug 4919145 */
1460: and event_gt.grouped_line_type = lines_gt.grouped_line_type