APPS.PA_BILL_REV_XLA_UPGRADE dependencies on PA_REV_AE_LINES_TMP

Line 546: INTO PA_REV_AE_LINES_TMP

542: and hr.org_information_context = 'Operating Unit Information';
543:
544: INSERT ALL
545: WHEN 1 = 1 THEN
546: INTO PA_REV_AE_LINES_TMP
547: (ae_header_id,
548: ae_line_num,
549: gl_batch_name,
550: code_combination_id,

Line 815: PA_REV_AE_LINES_TMP tmp

811:
812: UPDATE XLA_AE_LINES lin
813: SET lin.gl_sl_link_id = (SELECT gl_sl_link_id
814: FROM GL_IMPORT_REFERENCES imp,
815: PA_REV_AE_LINES_TMP tmp
816: WHERE imp.reference_6 = tmp.gl_batch_name
817: AND imp.reference_2 = tmp.code_combination_id
818: AND imp.reference_3 = tmp.dist_type
819: AND lin.ae_header_id = tmp.ae_header_id

Line 824: FROM PA_REV_AE_LINES_TMP tmp1

820: AND lin.ae_line_num = tmp.ae_line_num
821: AND imp.gl_sl_link_id is not null /*Bug 5168431*/
822: AND rownum =1)
823: WHERE EXISTS ( SELECT 1
824: FROM PA_REV_AE_LINES_TMP tmp1
825: WHERE lin.ae_header_id = tmp1.ae_header_id
826: AND lin.ae_line_num = tmp1.ae_line_num)
827: AND lin.application_id = 275
828: AND lin.gl_sl_link_id is null

Line 1241: INTO PA_REV_AE_LINES_TMP

1237: l_rows_processed := l_rows_processed + SQL%ROWCOUNT;
1238:
1239: INSERT ALL
1240: WHEN 1 = 1 THEN
1241: INTO PA_REV_AE_LINES_TMP
1242: (ae_header_id,
1243: ae_line_num,
1244: gl_batch_name,
1245: code_combination_id,

Line 1547: PA_REV_AE_LINES_TMP tmp

1543:
1544: UPDATE XLA_AE_LINES lin
1545: SET lin.gl_sl_link_id = (select gl_sl_link_id
1546: FROM GL_IMPORT_REFERENCES imp,
1547: PA_REV_AE_LINES_TMP tmp
1548: WHERE imp.reference_6 = tmp.gl_batch_name
1549: AND imp.reference_2 = tmp.code_combination_id
1550: AND imp.reference_3 = tmp.dist_type
1551: AND lin.ae_header_id = tmp.ae_header_id

Line 1556: FROM PA_REV_AE_LINES_TMP tmp1

1552: AND lin.ae_line_num = tmp.ae_line_num
1553: AND imp.gl_sl_link_id is not null /*Bug 5168431*/
1554: AND rownum=1)
1555: WHERE EXISTS ( SELECT 1
1556: FROM PA_REV_AE_LINES_TMP tmp1
1557: WHERE lin.ae_header_id = tmp1.ae_header_id
1558: AND lin.ae_line_num = tmp1.ae_line_num)
1559: AND lin.application_id = 275
1560: AND lin.gl_sl_link_id is null