APPS.AP_IMPORT_VALIDATION_PKG dependencies on AP_SYSTEM_PARAMETERS_ALL

Line 6557: l_make_rate_mand_flag AP_SYSTEM_PARAMETERS_ALL.MAKE_RATE_MANDATORY_FLAG%TYPE;

6553: current_calling_sequence VARCHAR2(2000);
6554: debug_info VARCHAR2(500);
6555:
6556: --bug 9326733 starts
6557: l_make_rate_mand_flag AP_SYSTEM_PARAMETERS_ALL.MAKE_RATE_MANDATORY_FLAG%TYPE;
6558:
6559: CURSOR c_get_rate_mand_flag(l_org_id IN NUMBER) IS
6560: select nvl(make_rate_mandatory_flag, 'N')
6561: from ap_system_parameters_all

Line 6561: from ap_system_parameters_all

6557: l_make_rate_mand_flag AP_SYSTEM_PARAMETERS_ALL.MAKE_RATE_MANDATORY_FLAG%TYPE;
6558:
6559: CURSOR c_get_rate_mand_flag(l_org_id IN NUMBER) IS
6560: select nvl(make_rate_mandatory_flag, 'N')
6561: from ap_system_parameters_all
6562: where org_id = l_org_id
6563: and multi_currency_flag = 'Y';
6564: --bug 9326733 ends
6565:

Line 20135: from ap_system_parameters_all

20131: ||P_calling_sequence;
20132:
20133: --Bug12612189
20134: select awt_include_tax_amt into l_awt_include_tax_amt
20135: from ap_system_parameters_all
20136: where ORG_ID=P_INVOICE_REC.ORG_ID;
20137:
20138: --bug12612189, start comment
20139: /*

Line 20338: from ap_system_parameters_all

20334: 'AP_IMPORT_VALIDATION_PKG.v_check_invalid_line_pay_awt_g<-'
20335: ||P_calling_sequence;
20336: --Bug11728066
20337: select awt_include_tax_amt into l_awt_include_tax_amt
20338: from ap_system_parameters_all
20339: where org_id=p_invoice_rec.org_id;
20340:
20341: IF p_invoice_lines_rec.line_type_lookup_code ='TAX' --l_awt_include_tax_amt check
20342: and nvl(l_awt_include_tax_amt ,'N') <> 'Y' THEN

Line 20634: l_income_tax_region_flag ap_system_parameters_all.income_tax_region_flag%TYPE;

20630: l_income_tax_type ap_income_tax_types.income_tax_type%TYPE;
20631: l_income_tax_region ap_income_tax_regions.region_short_name%TYPE;
20632:
20633: -- Bug 9189995
20634: l_income_tax_region_flag ap_system_parameters_all.income_tax_region_flag%TYPE;
20635:
20636: -- Bug 7599916
20637: Cursor c_type_1099(c_vendor_id NUMBER) Is
20638: Select pov.type_1099