APPS.PAY_US_SOE_BALANCES_PKG dependencies on PAY_US_LOCAL_TAXES_V

Line 2139: l_school_jd pay_us_local_taxes_v.jurisdiction_code%type;

2135: l_county_name pay_us_counties.county_name%type;
2136:
2137: l_school_code pay_us_school_dsts.school_dst_code%type;
2138: l_school_name pay_us_school_dsts.school_dst_name%type;
2139: l_school_jd pay_us_local_taxes_v.jurisdiction_code%type;
2140: l_juris_code pay_us_state_taxes_v.jurisdiction_code%type;
2141:
2142: l_count number;
2143: l_run_amount number;

Line 2146: l_tax_type pay_us_local_taxes_v.tax_type_code%type;

2142: l_count number;
2143: l_run_amount number;
2144: l_curr_amount number;
2145: l_ytd_amount number;
2146: l_tax_type pay_us_local_taxes_v.tax_type_code%type;
2147:
2148: start_cnt number;
2149: end_cnt number;
2150: i number :=0;

Line 2156: l_rep_name pay_us_local_taxes_v.user_reporting_name%TYPE;

2152: k number :=0;
2153: l_found boolean;
2154: l_pos number;
2155:
2156: l_rep_name pay_us_local_taxes_v.user_reporting_name%TYPE;
2157: l_city_name pay_us_local_taxes_v.city_name%TYPE;
2158: l_run_val number;
2159: l_ytd_val number;
2160:

Line 2157: l_city_name pay_us_local_taxes_v.city_name%TYPE;

2153: l_found boolean;
2154: l_pos number;
2155:
2156: l_rep_name pay_us_local_taxes_v.user_reporting_name%TYPE;
2157: l_city_name pay_us_local_taxes_v.city_name%TYPE;
2158: l_run_val number;
2159: l_ytd_val number;
2160:
2161: l_ytd_value number;

Line 2177: from pay_us_local_taxes_v

2173: tax_type_code,
2174: user_reporting_name,
2175: run_val,
2176: ytd_val
2177: from pay_us_local_taxes_v
2178: where ee_or_er_code = 'EE'
2179: and assignment_action_id = l_assignment_action_id
2180: order by user_reporting_name;
2181:

Line 2191: from pay_us_local_taxes_v pt

2187: jurisdiction_code,
2188: tax_type_code,
2189: user_reporting_name,
2190: sum(run_val)
2191: from pay_us_local_taxes_v pt
2192: where pt.ee_or_er_code = 'EE'
2193: and pt.assignment_action_id = cp_run_action_id
2194: group by user_reporting_name, city_name,jurisdiction_code, tax_type_code
2195: order by user_reporting_name;

Line 2205: from pay_us_local_taxes_v pt

2201: sum(pt.ytd_val) ,
2202: jurisdiction_code,
2203: tax_type_code,
2204: user_reporting_name
2205: from pay_us_local_taxes_v pt
2206: where pt.ee_or_er_code = 'EE'
2207: and pt.assignment_action_id = cp_master_action_id
2208: group by user_reporting_name, city_name,jurisdiction_code, tax_type_code
2209: order by user_reporting_name;

Line 2270: PROCEDURE get_position_local(p_rep_name in pay_us_local_taxes_v.user_reporting_name%TYPE ,

2266: -- Procedure to get the position of the local deductions in the plsql table
2267: -- If the element exists it will return the position otherwise will return
2268: -- new index where new element will be stored. The reporting name with the
2269: -- same city , jurisdiction or tax_type are grouped for SOE
2270: PROCEDURE get_position_local(p_rep_name in pay_us_local_taxes_v.user_reporting_name%TYPE ,
2271: p_tax_type_code in pay_us_local_taxes_v.tax_type_code%TYPE ,
2272: p_jurisdiction_code in pay_us_local_taxes_v.jurisdiction_code%type,
2273: p_city_name in pay_us_local_taxes_v.city_name%type,
2274: p_found out nocopy boolean,

Line 2271: p_tax_type_code in pay_us_local_taxes_v.tax_type_code%TYPE ,

2267: -- If the element exists it will return the position otherwise will return
2268: -- new index where new element will be stored. The reporting name with the
2269: -- same city , jurisdiction or tax_type are grouped for SOE
2270: PROCEDURE get_position_local(p_rep_name in pay_us_local_taxes_v.user_reporting_name%TYPE ,
2271: p_tax_type_code in pay_us_local_taxes_v.tax_type_code%TYPE ,
2272: p_jurisdiction_code in pay_us_local_taxes_v.jurisdiction_code%type,
2273: p_city_name in pay_us_local_taxes_v.city_name%type,
2274: p_found out nocopy boolean,
2275: p_index out nocopy number)

Line 2272: p_jurisdiction_code in pay_us_local_taxes_v.jurisdiction_code%type,

2268: -- new index where new element will be stored. The reporting name with the
2269: -- same city , jurisdiction or tax_type are grouped for SOE
2270: PROCEDURE get_position_local(p_rep_name in pay_us_local_taxes_v.user_reporting_name%TYPE ,
2271: p_tax_type_code in pay_us_local_taxes_v.tax_type_code%TYPE ,
2272: p_jurisdiction_code in pay_us_local_taxes_v.jurisdiction_code%type,
2273: p_city_name in pay_us_local_taxes_v.city_name%type,
2274: p_found out nocopy boolean,
2275: p_index out nocopy number)
2276: IS

Line 2273: p_city_name in pay_us_local_taxes_v.city_name%type,

2269: -- same city , jurisdiction or tax_type are grouped for SOE
2270: PROCEDURE get_position_local(p_rep_name in pay_us_local_taxes_v.user_reporting_name%TYPE ,
2271: p_tax_type_code in pay_us_local_taxes_v.tax_type_code%TYPE ,
2272: p_jurisdiction_code in pay_us_local_taxes_v.jurisdiction_code%type,
2273: p_city_name in pay_us_local_taxes_v.city_name%type,
2274: p_found out nocopy boolean,
2275: p_index out nocopy number)
2276: IS
2277: