DBA Data[Home] [Help]

APPS.AR_GTA_REPORTS_PKG dependencies on AR_GTA_AR_DIFFERENCE_TEMP

Line 3950: ar_gta_ar_difference_temp;

3946: CURSOR c_ar_diff_count IS
3947: SELECT
3948: count(*)
3949: FROM
3950: ar_gta_ar_difference_temp;
3951:
3952: CURSOR c_missing_artrx_count IS
3953: SELECT
3954: COUNT(*)

Line 3967: ar_gta_ar_difference_temp adt;

3963: ,adt.trx_date
3964: ,adt.customer_name
3965: ,adt.invoice_currency_code
3966: FROM
3967: ar_gta_ar_difference_temp adt;
3968:
3969: l_ar_difference c_ar_difference%ROWTYPE;
3970:
3971: /*Comment this part out for fix the bug 5263009

Line 5104: INSERT INTO ar_gta_ar_difference_temp(customer_trx_id

5100: );
5101:
5102: IF (l_header_difference OR l_line_difference OR l_has_unmatched)
5103: THEN
5104: INSERT INTO ar_gta_ar_difference_temp(customer_trx_id
5105: ,trx_number
5106: ,trx_date
5107: ,customer_name
5108: ,invoice_currency_code

Line 5151: INSERT INTO ar_gta_ar_difference_temp(customer_trx_id

5147: ,x_has_difference =>l_consolidated_difference
5148: );
5149: IF l_consolidated_difference
5150: THEN
5151: INSERT INTO ar_gta_ar_difference_temp(customer_trx_id
5152: ,trx_number
5153: ,trx_date
5154: ,customer_name
5155: ,invoice_currency_code