DBA Data[Home] [Help]

APPS.ZX_PO_REC_PKG dependencies on ZX_RATES_B

Line 148: FROM ZX_RATES_B

144:
145: pg_get_tax_recovery_rate_tab(i) := l_rec_rate;
146: BEGIN
147: SELECT TAX_RATE_ID INTO l_tax_rate_id
148: FROM ZX_RATES_B
149: WHERE NVL(source_id,tax_rate_id) = pg_tax_code_id_tab(i)
150: AND record_type_code='MIGRATED';
151: EXCEPTION
152: WHEN OTHERS THEN

Line 408: FROM ZX_RATES_B

404:
405: pg_get_tax_recovery_rate_tab(i) := l_rec_rate;
406: BEGIN
407: SELECT TAX_RATE_ID INTO l_tax_rate_id
408: FROM ZX_RATES_B
409: WHERE NVL(source_id,tax_rate_id) = pg_tax_code_id_tab(i)
410: AND record_type_code='MIGRATED';
411: EXCEPTION
412: WHEN OTHERS THEN

Line 486: FROM ZX_RATES_B

482:
483: pg_get_tax_recovery_rate_tab(i) := l_rec_rate;
484: BEGIN
485: SELECT TAX_RATE_ID INTO l_tax_rate_id
486: FROM ZX_RATES_B
487: WHERE NVL(source_id,tax_rate_id) = pg_tax_code_id_tab(i)
488: AND record_type_code='MIGRATED';
489: EXCEPTION
490: WHEN OTHERS THEN

Line 690: FROM ZX_RATES_B

686:
687: pg_get_tax_recovery_rate_tab(i) := l_rec_rate;
688: BEGIN
689: SELECT TAX_RATE_ID INTO l_tax_rate_id
690: FROM ZX_RATES_B
691: WHERE NVL(source_id,tax_rate_id) = pg_tax_code_id_tab(i)
692: AND record_type_code='MIGRATED';
693: EXCEPTION
694: WHEN OTHERS THEN