APPS.JMF_GTA_SPLIT_TRX_PROC dependencies on JMF_GTA_TAX_LIMITS_ALL

Line 1635: l_max_amount jmf_gta_tax_limits_all.max_amount%TYPE;

1631: IS
1632: l_procedure_name VARCHAR2(30) := 'judge_cm_limit';
1633: l_gta_trx Jmf_Gta_Trx_Util.trx_rec_type;
1634: l_fp_reg_num jmf_gta_trx_headers_all.fp_tax_registration_number%TYPE;
1635: l_max_amount jmf_gta_tax_limits_all.max_amount%TYPE;
1636: l_max_line jmf_gta_tax_limits_all.max_num_of_line%TYPE;
1637: l_lines_number NUMBER;
1638: l_sum_of_amount NUMBER;
1639: l_trx_line_index NUMBER;

Line 1636: l_max_line jmf_gta_tax_limits_all.max_num_of_line%TYPE;

1632: l_procedure_name VARCHAR2(30) := 'judge_cm_limit';
1633: l_gta_trx Jmf_Gta_Trx_Util.trx_rec_type;
1634: l_fp_reg_num jmf_gta_trx_headers_all.fp_tax_registration_number%TYPE;
1635: l_max_amount jmf_gta_tax_limits_all.max_amount%TYPE;
1636: l_max_line jmf_gta_tax_limits_all.max_num_of_line%TYPE;
1637: l_lines_number NUMBER;
1638: l_sum_of_amount NUMBER;
1639: l_trx_line_index NUMBER;
1640: l_invoice_type jmf_gta_trx_headers_all.invoice_type%TYPE; --added by subba for R12.1

Line 1669: jmf_gta_tax_limits_all limits

1665: INTO
1666: l_max_amount
1667: , l_max_line
1668: FROM
1669: jmf_gta_tax_limits_all limits
1670: WHERE limits.fp_tax_registration_number = l_fp_reg_num
1671: AND limits.invoice_type = l_invoice_type
1672: AND limits.org_id = p_org_id;
1673:

Line 1834: jmf_gta_tax_limits_all limits

1830: INTO
1831: l_max_amount
1832: , l_max_line
1833: FROM
1834: jmf_gta_tax_limits_all limits
1835: WHERE limits.fp_tax_registration_number = l_fp_reg_num
1836: AND limits.org_id = p_org_id;
1837:
1838: EXCEPTION

Line 1872: jmf_gta_tax_limits_all jgtla

1868: INTO
1869: l_max_amount
1870: , l_max_line
1871: FROM
1872: jmf_gta_tax_limits_all jgtla
1873: WHERE jgtla.fp_tax_registration_number = l_fp_reg_num
1874: AND jgtla.invoice_type = l_gta_trx.trx_header.invoice_type
1875: AND jgtla.org_id = p_org_id;
1876: