DBA Data[Home] [Help]

APPS.IGC_CC_BUDGETARY_CTRL_PKG dependencies on AP_TAX_CODES

Line 6633: p_tax_id IN ap_tax_codes.tax_id%TYPE,

6629: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
6630: x_return_status OUT NOCOPY VARCHAR2,
6631: x_msg_count OUT NOCOPY NUMBER,
6632: x_msg_data OUT NOCOPY VARCHAR2,
6633: p_tax_id IN ap_tax_codes.tax_id%TYPE,
6634: p_amount IN NUMBER,
6635: p_tax_amount OUT NOCOPY NUMBER)
6636: IS
6637: CURSOR c_get_tax IS

Line 6640: FROM ap_tax_codes a,

6636: IS
6637: CURSOR c_get_tax IS
6638: SELECT Nvl(tax_recovery_rate,100),
6639: Nvl(tax_rate,0)
6640: FROM ap_tax_codes a,
6641: financials_system_parameters b
6642: WHERE a.set_of_books_id = b.set_of_books_id
6643: AND a.tax_id = p_tax_id;
6644:

Line 6648: l_tax_recovery_rate ap_tax_codes.tax_recovery_rate%TYPE;

6644:
6645:
6646: l_api_name CONSTANT VARCHAR2(30) := 'Calculate_Nonrec_Tax';
6647: l_api_version CONSTANT NUMBER := 1.0;
6648: l_tax_recovery_rate ap_tax_codes.tax_recovery_rate%TYPE;
6649: l_tax_rate ap_tax_codes.tax_rate%TYPE;
6650: l_full_path VARCHAR2(255);
6651:
6652: BEGIN

Line 6649: l_tax_rate ap_tax_codes.tax_rate%TYPE;

6645:
6646: l_api_name CONSTANT VARCHAR2(30) := 'Calculate_Nonrec_Tax';
6647: l_api_version CONSTANT NUMBER := 1.0;
6648: l_tax_recovery_rate ap_tax_codes.tax_recovery_rate%TYPE;
6649: l_tax_rate ap_tax_codes.tax_rate%TYPE;
6650: l_full_path VARCHAR2(255);
6651:
6652: BEGIN
6653: