DBA Data[Home] [Help]

APPS.AR_GTA_REPORTS_PKG dependencies on AR_GTA_UNMATCHED_TEMP

Line 3646: --table ar_gta_unmatched_temp

3642: WHILE c_gta_unmatched_line%FOUND
3643: LOOP
3644:
3645: --INSERT unmatched GTA lines belong to current AR to temp
3646: --table ar_gta_unmatched_temp
3647: INSERT INTO ar_gta_unmatched_temp(source
3648: ,ar_header_id
3649: ,invoice_number
3650: ,tp_tax_registration_number

Line 3647: INSERT INTO ar_gta_unmatched_temp(source

3643: LOOP
3644:
3645: --INSERT unmatched GTA lines belong to current AR to temp
3646: --table ar_gta_unmatched_temp
3647: INSERT INTO ar_gta_unmatched_temp(source
3648: ,ar_header_id
3649: ,invoice_number
3650: ,tp_tax_registration_number
3651: ,line_number

Line 3688: --table ar_gta_unmatched_temp

3684: WHILE c_gt_unmatched_line%FOUND
3685: LOOP
3686:
3687: --INSERT unmatched GT lines belong to current AR to temp
3688: --table ar_gta_unmatched_temp
3689: INSERT INTO ar_gta_unmatched_temp(source
3690: ,ar_header_id
3691: ,invoice_number
3692: ,tp_tax_registration_number

Line 3689: INSERT INTO ar_gta_unmatched_temp(source

3685: LOOP
3686:
3687: --INSERT unmatched GT lines belong to current AR to temp
3688: --table ar_gta_unmatched_temp
3689: INSERT INTO ar_gta_unmatched_temp(source
3690: ,ar_header_id
3691: ,invoice_number
3692: ,tp_tax_registration_number
3693: ,line_number

Line 4053: ar_gta_unmatched_temp

4049: )
4050: )
4051:
4052: FROM
4053: ar_gta_unmatched_temp
4054: WHERE ar_header_id=l_ar_header_id
4055: ORDER BY source DESC;
4056:
4057: CURSOR c_missing_artrx_xml IS