[Home] [Help]
933: l_ext_end_date date;
934:
935: l_ben_start_date date;
936:
937: l_def_bal_id pay_defined_balances.defined_balance_id%type;
938:
939: cursor csr_get_odd_def_bal_id is
940: select pdb.defined_balance_id
941: from pay_balance_types pbt,
938:
939: cursor csr_get_odd_def_bal_id is
940: select pdb.defined_balance_id
941: from pay_balance_types pbt,
942: pay_defined_balances pdb,
943: pay_balance_dimensions pbd
944: where pbt.balance_type_id = pdb.balance_type_id
945: and pdb.balance_dimension_id = pbd.balance_dimension_id
946: and pbt.balance_name = 'Mileage Odd Taxable Amt'
948:
949: cursor csr_get_even_def_bal_id is
950: select pdb.defined_balance_id
951: from pay_balance_types pbt,
952: pay_defined_balances pdb,
953: pay_balance_dimensions pbd
954: where pbt.balance_type_id = pdb.balance_type_id
955: and pdb.balance_dimension_id = pbd.balance_dimension_id
956: and pbt.balance_name = 'Mileage Even Taxable Amt'
1085: l_ext_end_date date;
1086:
1087: l_ben_start_date date;
1088:
1089: l_def_bal_id pay_defined_balances.defined_balance_id%type;
1090:
1091: cursor csr_get_odd_def_bal_id is
1092: select pdb.defined_balance_id
1093: from pay_balance_types pbt,
1090:
1091: cursor csr_get_odd_def_bal_id is
1092: select pdb.defined_balance_id
1093: from pay_balance_types pbt,
1094: pay_defined_balances pdb,
1095: pay_balance_dimensions pbd
1096: where pbt.balance_type_id = pdb.balance_type_id
1097: and pdb.balance_dimension_id = pbd.balance_dimension_id
1098: and pbt.balance_name = 'Addl Pasg Odd Taxable Amt'
1100:
1101: cursor csr_get_even_def_bal_id is
1102: select pdb.defined_balance_id
1103: from pay_balance_types pbt,
1104: pay_defined_balances pdb,
1105: pay_balance_dimensions pbd
1106: where pbt.balance_type_id = pdb.balance_type_id
1107: and pdb.balance_dimension_id = pbd.balance_dimension_id
1108: and pbt.balance_name = 'Addl Pasg Even Taxable Amt'
1244:
1245: cursor get_odd_miles_bal_id is
1246: select pdb.defined_balance_id
1247: from pay_balance_types pbt,
1248: pay_defined_balances pdb,
1249: pay_balance_dimensions pbd
1250: where pbt.balance_type_id = pdb.balance_type_id
1251: and pdb.balance_dimension_id = pbd.balance_dimension_id
1252: and pbt.balance_name in ('Car Casual Odd Actual Miles',
1259:
1260: cursor get_even_miles_bal_id is
1261: select pdb.defined_balance_id
1262: from pay_balance_types pbt,
1263: pay_defined_balances pdb,
1264: pay_balance_dimensions pbd
1265: where pbt.balance_type_id = pdb.balance_type_id
1266: and pdb.balance_dimension_id = pbd.balance_dimension_id
1267: and pbt.balance_name in ('Car Casual Even Actual Miles',
2027: l_pbm_bal_string varchar2(1000);
2028: l_tpp_bal_string varchar2(1000);
2029:
2030: TYPE r_def_bal IS RECORD
2031: (def_bal_id pay_defined_balances.defined_balance_id%type
2032: ,bal_name pay_balance_types.balance_name%type);
2033:
2034: TYPE t_def_bal IS TABLE OF r_def_bal
2035: INDEX BY BINARY_INTEGER;
2301: l_tye_balance_temp number;
2302: l_sql_stmt varchar2(2000);
2303:
2304: TYPE r_def_bal IS RECORD
2305: (def_bal_id pay_defined_balances.defined_balance_id%type
2306: ,bal_name pay_balance_types.balance_name%type);
2307:
2308: TYPE t_def_bal IS TABLE OF r_def_bal
2309: INDEX BY BINARY_INTEGER;
2326: l_sql_stmt :=
2327: 'select pdb.defined_balance_id,
2328: pbt.balance_name
2329: from pay_balance_types pbt,
2330: pay_defined_balances pdb,
2331: pay_balance_dimensions pbd
2332: where pbt.balance_type_id = pdb.balance_type_id
2333: and pdb.balance_dimension_id = pbd.balance_dimension_id
2334: and pbd.dimension_name = '||'''_ASG_TD_YTD'''||