APPS.AR_GTA_SPLIT_TRX_PROC dependencies on AR_GTA_TAX_LIMITS_ALL

Line 2044: l_max_amount ar_gta_tax_limits_all.max_amount%TYPE;

2040: IS
2041: l_procedure_name VARCHAR2(30) := 'judge_cm_limit';
2042: l_gta_trx AR_Gta_Trx_Util.trx_rec_type;
2043: l_fp_reg_num ar_gta_trx_headers_all.fp_tax_registration_number%TYPE;
2044: l_max_amount ar_gta_tax_limits_all.max_amount%TYPE;
2045: l_max_line ar_gta_tax_limits_all.max_num_of_line%TYPE;
2046: l_lines_number NUMBER;
2047: l_sum_of_amount NUMBER;
2048: l_trx_line_index NUMBER;

Line 2045: l_max_line ar_gta_tax_limits_all.max_num_of_line%TYPE;

2041: l_procedure_name VARCHAR2(30) := 'judge_cm_limit';
2042: l_gta_trx AR_Gta_Trx_Util.trx_rec_type;
2043: l_fp_reg_num ar_gta_trx_headers_all.fp_tax_registration_number%TYPE;
2044: l_max_amount ar_gta_tax_limits_all.max_amount%TYPE;
2045: l_max_line ar_gta_tax_limits_all.max_num_of_line%TYPE;
2046: l_lines_number NUMBER;
2047: l_sum_of_amount NUMBER;
2048: l_trx_line_index NUMBER;
2049: l_invoice_type ar_gta_trx_headers_all.invoice_type%TYPE; --added by subba for R12.1

Line 2079: ar_gta_tax_limits_all limits

2075: INTO
2076: l_max_amount
2077: , l_max_line
2078: FROM
2079: ar_gta_tax_limits_all limits
2080: WHERE limits.fp_tax_registration_number = l_fp_reg_num
2081: AND limits.invoice_type = l_invoice_type
2082: AND limits.org_id = p_org_id;
2083:

Line 2245: ar_gta_tax_limits_all limits

2241: INTO
2242: l_max_amount
2243: , l_max_line
2244: FROM
2245: ar_gta_tax_limits_all limits
2246: WHERE limits.fp_tax_registration_number = l_fp_reg_num
2247: AND limits.org_id = p_org_id;
2248:
2249: EXCEPTION

Line 2284: ar_gta_tax_limits_all jgtla

2280: INTO
2281: l_max_amount
2282: , l_max_line
2283: FROM
2284: ar_gta_tax_limits_all jgtla
2285: WHERE jgtla.fp_tax_registration_number = l_fp_reg_num
2286: AND jgtla.invoice_type = l_gta_trx.trx_header.invoice_type
2287: AND jgtla.org_id = p_org_id;
2288: