APPS.PAY_GB_P11D_MILEAGE_EXTRACT dependencies on PAY_BALANCE_DIMENSIONS

Line 943: pay_balance_dimensions pbd

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'
947: and pbd.dimension_name = '_ASG_YTD';

Line 953: pay_balance_dimensions pbd

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'
957: and pbd.dimension_name = '_ASG_YTD';

Line 1095: pay_balance_dimensions pbd

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'
1099: and pbd.dimension_name = '_ASG_YTD';

Line 1105: pay_balance_dimensions pbd

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'
1109: and pbd.dimension_name = '_ASG_YTD';

Line 1249: pay_balance_dimensions pbd

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',
1253: 'Motorcycle Casual Odd Actual Miles',

Line 1264: pay_balance_dimensions pbd

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',
1268: 'Motorcycle Casual Even Actual Miles',

Line 2331: pay_balance_dimensions pbd

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'''||
2335: 'and pbt.balance_name in ' || p_bal_string ;