APPS.PAY_US_SOE_BALANCES_PKG dependencies on PAY_US_FED_TAXES_V

Line 1228: l_tax_type pay_us_fed_taxes_v.tax_type_code%TYPE;

1224: l_count number;
1225: l_run_amount number;
1226: l_curr_amount number;
1227: l_ytd_amount number;
1228: l_tax_type pay_us_fed_taxes_v.tax_type_code%TYPE;
1229:
1230: start_cnt number;
1231: end_cnt number;
1232: i number :=0;

Line 1238: l_rep_name pay_us_fed_taxes_v.user_reporting_name%TYPE;

1234: k number :=0;
1235: l_found boolean;
1236: l_pos number;
1237:
1238: l_rep_name pay_us_fed_taxes_v.user_reporting_name%TYPE;
1239: l_run_val number;
1240: l_ytd_val number;
1241: l_procedure varchar2(20) ;
1242:

Line 1254: FROM pay_us_fed_taxes_v

1250: SELECT user_reporting_name,
1251: run_val,
1252: ytd_val,
1253: tax_type_code
1254: FROM pay_us_fed_taxes_v
1255: WHERE ee_or_er_code = 'EE'
1256: AND balance_category_code in ('WITHHELD','ADVANCED')
1257: AND assignment_action_id = l_assignment_action_id
1258: ORDER BY user_reporting_name;

Line 1266: from pay_us_fed_taxes_v pt

1262: IS
1263: select pt.user_reporting_name
1264: ,sum(pt.run_val)
1265: ,pt.tax_type_code
1266: from pay_us_fed_taxes_v pt
1267: where pt.ee_or_er_code = 'EE'
1268: and pt.balance_category_code in ('WITHHELD','ADVANCED')
1269: and pt.assignment_action_id = cp_run_action_id
1270: group by pt.user_reporting_name,tax_type_code

Line 1280: from pay_us_fed_taxes_v pt

1276: IS
1277: select sum(pt.ytd_val) ,
1278: pt.user_reporting_name,
1279: tax_type_code
1280: from pay_us_fed_taxes_v pt
1281: where pt.ee_or_er_code = 'EE'
1282: and pt.balance_category_code in ('WITHHELD','ADVANCED')
1283: and pt.assignment_action_id = cp_master_action_id
1284: group by pt.user_reporting_name,tax_type_code ;

Line 1342: PROCEDURE get_position_fed (p_rep_name in pay_us_fed_taxes_v.user_reporting_name%TYPE ,

1338:
1339: -- Procedure to get the position of the federal deductions in the plsql table
1340: -- If the element exists it will return the position otherwise will return
1341: -- new index where new element will be stored.
1342: PROCEDURE get_position_fed (p_rep_name in pay_us_fed_taxes_v.user_reporting_name%TYPE ,
1343: p_tax_type_code in pay_us_fed_taxes_v.tax_type_code%type,
1344: p_found out nocopy boolean,
1345: p_index out nocopy number)
1346: IS

Line 1343: p_tax_type_code in pay_us_fed_taxes_v.tax_type_code%type,

1339: -- Procedure to get the position of the federal deductions in the plsql table
1340: -- If the element exists it will return the position otherwise will return
1341: -- new index where new element will be stored.
1342: PROCEDURE get_position_fed (p_rep_name in pay_us_fed_taxes_v.user_reporting_name%TYPE ,
1343: p_tax_type_code in pay_us_fed_taxes_v.tax_type_code%type,
1344: p_found out nocopy boolean,
1345: p_index out nocopy number)
1346: IS
1347: st_cnt number;