APPS.PA_XLA_UPGRADE dependencies on PA_XLA_UPG_EVENTS_GT

Line 537: INTO PA_XLA_UPG_EVENTS_GT

533: l_user,
534: l_pa_app_id,
535: l_request_id
536: )
537: INTO PA_XLA_UPG_EVENTS_GT
538: (expenditure_item_id,
539: event_id,
540: grouped_line_type,
541: event_date,

Line 749: PA_XLA_UPG_EVENTS_GT event_gt

745: lines_gt.reference_3,
746: lines_gt.ledger_id,
747: lines_gt.gl_date
748: from PA_XLA_UPG_LINES_GT lines_gt,
749: PA_XLA_UPG_EVENTS_GT event_gt
750: where event_gt.expenditure_item_id = lines_gt.expenditure_item_id
751: and event_gt.event_date = lines_gt.gl_date
752: and event_gt.grouped_line_type = lines_gt.grouped_line_type
753: );

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

757:
758:
759: UPDATE /*+ INDEX(cdl, PA_COST_DISTRIBUTION_LINES_U1) */
760: pa_cost_distribution_lines_all cdl
761: SET cdl.acct_event_id = (select /*+ INDEX(event_gt, PA_XLA_UPG_EVENTS_GT_N1) */
762: event_gt.event_id from PA_XLA_UPG_EVENTS_GT event_gt
763: where cdl.expenditure_item_id = event_gt.expenditure_item_id
764: and cdl.gl_date = event_gt.event_date
765: and decode(cdl.line_type, 'R', 'R', 'B' ) = event_gt.grouped_line_type

Line 762: event_gt.event_id from PA_XLA_UPG_EVENTS_GT event_gt

758:
759: UPDATE /*+ INDEX(cdl, PA_COST_DISTRIBUTION_LINES_U1) */
760: pa_cost_distribution_lines_all cdl
761: SET cdl.acct_event_id = (select /*+ INDEX(event_gt, PA_XLA_UPG_EVENTS_GT_N1) */
762: event_gt.event_id from PA_XLA_UPG_EVENTS_GT event_gt
763: where cdl.expenditure_item_id = event_gt.expenditure_item_id
764: and cdl.gl_date = event_gt.event_date
765: and decode(cdl.line_type, 'R', 'R', 'B' ) = event_gt.grouped_line_type
766: and rownum = 1)

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

776:
777:
778: UPDATE /*+ INDEX(cdl, PA_CC_DIST_LINES_U2) */
779: PA_CC_DIST_LINES_ALL cdl
780: SET cdl.acct_event_id = (select /*+ INDEX(event_gt, PA_XLA_UPG_EVENTS_GT_N1) */
781: event_gt.event_id from PA_XLA_UPG_EVENTS_GT event_gt
782: where cdl.expenditure_item_id = event_gt.expenditure_item_id
783: and cdl.gl_date = event_gt.event_date
784: and cdl.line_type = event_gt.grouped_line_type

Line 781: event_gt.event_id from PA_XLA_UPG_EVENTS_GT event_gt

777:
778: UPDATE /*+ INDEX(cdl, PA_CC_DIST_LINES_U2) */
779: PA_CC_DIST_LINES_ALL cdl
780: SET cdl.acct_event_id = (select /*+ INDEX(event_gt, PA_XLA_UPG_EVENTS_GT_N1) */
781: event_gt.event_id from PA_XLA_UPG_EVENTS_GT event_gt
782: where cdl.expenditure_item_id = event_gt.expenditure_item_id
783: and cdl.gl_date = event_gt.event_date
784: and cdl.line_type = event_gt.grouped_line_type
785: and rownum = 1)

Line 1226: INTO PA_XLA_UPG_EVENTS_GT

1222: l_user,
1223: l_pa_app_id,
1224: l_request_id
1225: )
1226: INTO PA_XLA_UPG_EVENTS_GT
1227: (expenditure_item_id,
1228: event_id,
1229: grouped_line_type,
1230: event_date,

Line 1445: PA_XLA_UPG_EVENTS_GT event_gt

1441: lines_gt.reference_3,
1442: lines_gt.ledger_id,
1443: lines_gt.gl_date
1444: from PA_XLA_UPG_LINES_GT lines_gt,
1445: PA_XLA_UPG_EVENTS_GT event_gt
1446: where event_gt.expenditure_item_id = lines_gt.expenditure_item_id
1447: and event_gt.event_date = lines_gt.gl_date
1448: and event_gt.ledger_id = lines_gt.ledger_id /* Added for bug 4919145 */
1449: and event_gt.grouped_line_type = lines_gt.grouped_line_type