DBA Data[Home] [Help]

APPS.ZX_PO_REC_PKG dependencies on ZX_RATES_B

Line 152: FROM ZX_RATES_B

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

Line 412: FROM ZX_RATES_B

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

Line 490: FROM ZX_RATES_B

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

Line 694: FROM ZX_RATES_B

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