APPS.PA_XLA_UPGRADE dependencies on PA_REV_AE_LINES_TMP

Line 674: INTO PA_REV_AE_LINES_TMP

670: acct_dr,
671: acct_cr,
672: entered_dr,
673: entered_cr)
674: INTO PA_REV_AE_LINES_TMP
675: (ae_header_id,
676: ae_line_num,
677: gl_batch_name,
678: code_combination_id,

Line 810: SET gl_sl_link_id = (SELECT /*+ INDEX(tmp, PA_REV_AE_LINES_TMP_U1) */

806:
807: BEGIN
808:
809: UPDATE XLA_AE_LINES xal
810: SET gl_sl_link_id = (SELECT /*+ INDEX(tmp, PA_REV_AE_LINES_TMP_U1) */
811: gl_sl_link_id
812: FROM GL_IMPORT_REFERENCES imp,
813: PA_REV_AE_LINES_TMP tmp
814: WHERE xal.ae_header_id = tmp.ae_header_id

Line 813: PA_REV_AE_LINES_TMP tmp

809: UPDATE XLA_AE_LINES xal
810: SET gl_sl_link_id = (SELECT /*+ INDEX(tmp, PA_REV_AE_LINES_TMP_U1) */
811: gl_sl_link_id
812: FROM GL_IMPORT_REFERENCES imp,
813: PA_REV_AE_LINES_TMP tmp
814: WHERE xal.ae_header_id = tmp.ae_header_id
815: AND xal.ae_line_num = tmp.ae_line_num
816: AND tmp.gl_batch_name = imp.reference_6
817: AND tmp.code_combination_id = nvl(imp.reference_2,-99)

Line 823: AND EXISTS ( SELECT /*+ INDEX(tmp1, PA_REV_AE_LINES_TMP_U1) */ 1

819: AND ROWNUM = 1)
820: WHERE application_id = l_pa_app_id
821: AND upg_batch_id = p_upg_batch_id
822: AND gl_sl_link_id is null
823: AND EXISTS ( SELECT /*+ INDEX(tmp1, PA_REV_AE_LINES_TMP_U1) */ 1
824: FROM PA_REV_AE_LINES_TMP tmp1
825: WHERE xal.ae_header_id = tmp1.ae_header_id
826: AND xal.ae_line_num = tmp1.ae_line_num);
827:

Line 824: FROM PA_REV_AE_LINES_TMP tmp1

820: WHERE application_id = l_pa_app_id
821: AND upg_batch_id = p_upg_batch_id
822: AND gl_sl_link_id is null
823: AND EXISTS ( SELECT /*+ INDEX(tmp1, PA_REV_AE_LINES_TMP_U1) */ 1
824: FROM PA_REV_AE_LINES_TMP tmp1
825: WHERE xal.ae_header_id = tmp1.ae_header_id
826: AND xal.ae_line_num = tmp1.ae_line_num);
827:
828: EXCEPTION

Line 1364: INTO PA_REV_AE_LINES_TMP

1360: acct_dr,
1361: acct_cr,
1362: entered_dr,
1363: entered_cr)
1364: INTO PA_REV_AE_LINES_TMP
1365: (ae_header_id,
1366: ae_line_num,
1367: gl_batch_name,
1368: code_combination_id,

Line 1480: SET gl_sl_link_id = (SELECT /*+ INDEX(tmp, PA_REV_AE_LINES_TMP_U1) */

1476:
1477: BEGIN
1478:
1479: UPDATE XLA_AE_LINES xal
1480: SET gl_sl_link_id = (SELECT /*+ INDEX(tmp, PA_REV_AE_LINES_TMP_U1) */
1481: gl_sl_link_id
1482: FROM GL_IMPORT_REFERENCES imp,
1483: PA_REV_AE_LINES_TMP tmp
1484: WHERE xal.ae_header_id = tmp.ae_header_id

Line 1483: PA_REV_AE_LINES_TMP tmp

1479: UPDATE XLA_AE_LINES xal
1480: SET gl_sl_link_id = (SELECT /*+ INDEX(tmp, PA_REV_AE_LINES_TMP_U1) */
1481: gl_sl_link_id
1482: FROM GL_IMPORT_REFERENCES imp,
1483: PA_REV_AE_LINES_TMP tmp
1484: WHERE xal.ae_header_id = tmp.ae_header_id
1485: AND xal.ae_line_num = tmp.ae_line_num
1486: AND tmp.gl_batch_name = imp.reference_6
1487: AND tmp.code_combination_id = nvl(imp.reference_2,-99)

Line 1493: AND EXISTS ( SELECT /*+ INDEX(tmp1, PA_REV_AE_LINES_TMP_U1) */ 1

1489: AND ROWNUM = 1)
1490: WHERE application_id = l_pa_app_id
1491: AND upg_batch_id = p_upg_batch_id
1492: AND gl_sl_link_id is null
1493: AND EXISTS ( SELECT /*+ INDEX(tmp1, PA_REV_AE_LINES_TMP_U1) */ 1
1494: FROM PA_REV_AE_LINES_TMP tmp1
1495: WHERE xal.ae_header_id = tmp1.ae_header_id
1496: AND xal.ae_line_num = tmp1.ae_line_num);
1497:

Line 1494: FROM PA_REV_AE_LINES_TMP tmp1

1490: WHERE application_id = l_pa_app_id
1491: AND upg_batch_id = p_upg_batch_id
1492: AND gl_sl_link_id is null
1493: AND EXISTS ( SELECT /*+ INDEX(tmp1, PA_REV_AE_LINES_TMP_U1) */ 1
1494: FROM PA_REV_AE_LINES_TMP tmp1
1495: WHERE xal.ae_header_id = tmp1.ae_header_id
1496: AND xal.ae_line_num = tmp1.ae_line_num);
1497:
1498: EXCEPTION