APPS.PA_XLA_UPGRADE dependencies on PA_REV_AE_LINES_TMP

Line 684: INTO PA_REV_AE_LINES_TMP

680: acct_dr,
681: acct_cr,
682: entered_dr,
683: entered_cr)
684: INTO PA_REV_AE_LINES_TMP
685: (ae_header_id,
686: ae_line_num,
687: gl_batch_name,
688: code_combination_id,

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

816:
817: BEGIN
818:
819: UPDATE XLA_AE_LINES xal
820: SET gl_sl_link_id = (SELECT /*+ INDEX(tmp, PA_REV_AE_LINES_TMP_U1) */
821: gl_sl_link_id
822: FROM GL_IMPORT_REFERENCES imp,
823: PA_REV_AE_LINES_TMP tmp
824: WHERE xal.ae_header_id = tmp.ae_header_id

Line 823: PA_REV_AE_LINES_TMP tmp

819: UPDATE XLA_AE_LINES xal
820: SET gl_sl_link_id = (SELECT /*+ INDEX(tmp, PA_REV_AE_LINES_TMP_U1) */
821: gl_sl_link_id
822: FROM GL_IMPORT_REFERENCES imp,
823: PA_REV_AE_LINES_TMP tmp
824: WHERE xal.ae_header_id = tmp.ae_header_id
825: AND xal.ae_line_num = tmp.ae_line_num
826: AND tmp.gl_batch_name = imp.reference_6
827: AND tmp.code_combination_id = nvl(imp.reference_2,-99)

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

830: gl_sl_link_table = 'XLAJEL' /* Added for Bug 10302541 */
831: WHERE application_id = l_pa_app_id
832: AND upg_batch_id = p_upg_batch_id
833: AND gl_sl_link_id is null
834: AND EXISTS ( SELECT /*+ INDEX(tmp1, PA_REV_AE_LINES_TMP_U1) */ 1
835: FROM PA_REV_AE_LINES_TMP tmp1
836: WHERE xal.ae_header_id = tmp1.ae_header_id
837: AND xal.ae_line_num = tmp1.ae_line_num);
838:

Line 835: FROM PA_REV_AE_LINES_TMP tmp1

831: WHERE application_id = l_pa_app_id
832: AND upg_batch_id = p_upg_batch_id
833: AND gl_sl_link_id is null
834: AND EXISTS ( SELECT /*+ INDEX(tmp1, PA_REV_AE_LINES_TMP_U1) */ 1
835: FROM PA_REV_AE_LINES_TMP tmp1
836: WHERE xal.ae_header_id = tmp1.ae_header_id
837: AND xal.ae_line_num = tmp1.ae_line_num);
838:
839: EXCEPTION

Line 1375: INTO PA_REV_AE_LINES_TMP

1371: acct_dr,
1372: acct_cr,
1373: entered_dr,
1374: entered_cr)
1375: INTO PA_REV_AE_LINES_TMP
1376: (ae_header_id,
1377: ae_line_num,
1378: gl_batch_name,
1379: code_combination_id,

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

1487:
1488: BEGIN
1489:
1490: UPDATE XLA_AE_LINES xal
1491: SET gl_sl_link_id = (SELECT /*+ INDEX(tmp, PA_REV_AE_LINES_TMP_U1) */
1492: gl_sl_link_id
1493: FROM GL_IMPORT_REFERENCES imp,
1494: PA_REV_AE_LINES_TMP tmp
1495: WHERE xal.ae_header_id = tmp.ae_header_id

Line 1494: PA_REV_AE_LINES_TMP tmp

1490: UPDATE XLA_AE_LINES xal
1491: SET gl_sl_link_id = (SELECT /*+ INDEX(tmp, PA_REV_AE_LINES_TMP_U1) */
1492: gl_sl_link_id
1493: FROM GL_IMPORT_REFERENCES imp,
1494: PA_REV_AE_LINES_TMP tmp
1495: WHERE xal.ae_header_id = tmp.ae_header_id
1496: AND xal.ae_line_num = tmp.ae_line_num
1497: AND tmp.gl_batch_name = imp.reference_6
1498: AND tmp.code_combination_id = nvl(imp.reference_2,-99)

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

1501: gl_sl_link_table = 'XLAJEL' /* Added for Bug 10302541 */
1502: WHERE application_id = l_pa_app_id
1503: AND upg_batch_id = p_upg_batch_id
1504: AND gl_sl_link_id is null
1505: AND EXISTS ( SELECT /*+ INDEX(tmp1, PA_REV_AE_LINES_TMP_U1) */ 1
1506: FROM PA_REV_AE_LINES_TMP tmp1
1507: WHERE xal.ae_header_id = tmp1.ae_header_id
1508: AND xal.ae_line_num = tmp1.ae_line_num);
1509:

Line 1506: FROM PA_REV_AE_LINES_TMP tmp1

1502: WHERE application_id = l_pa_app_id
1503: AND upg_batch_id = p_upg_batch_id
1504: AND gl_sl_link_id is null
1505: AND EXISTS ( SELECT /*+ INDEX(tmp1, PA_REV_AE_LINES_TMP_U1) */ 1
1506: FROM PA_REV_AE_LINES_TMP tmp1
1507: WHERE xal.ae_header_id = tmp1.ae_header_id
1508: AND xal.ae_line_num = tmp1.ae_line_num);
1509:
1510: EXCEPTION