APPS.PAY_GB_P11D_MILEAGE_EXTRACT dependencies on PAY_BALANCE_DIMENSIONS

Line 904: pay_balance_dimensions pbd

900: cursor csr_get_odd_def_bal_id is
901: select pdb.defined_balance_id
902: from pay_balance_types pbt,
903: pay_defined_balances pdb,
904: pay_balance_dimensions pbd
905: where pbt.balance_type_id = pdb.balance_type_id
906: and pdb.balance_dimension_id = pbd.balance_dimension_id
907: and pbt.balance_name = 'Mileage Odd Taxable Amt'
908: and pbd.dimension_name = '_ASG_YTD';

Line 914: pay_balance_dimensions pbd

910: cursor csr_get_even_def_bal_id is
911: select pdb.defined_balance_id
912: from pay_balance_types pbt,
913: pay_defined_balances pdb,
914: pay_balance_dimensions pbd
915: where pbt.balance_type_id = pdb.balance_type_id
916: and pdb.balance_dimension_id = pbd.balance_dimension_id
917: and pbt.balance_name = 'Mileage Even Taxable Amt'
918: and pbd.dimension_name = '_ASG_YTD';

Line 1056: pay_balance_dimensions pbd

1052: cursor csr_get_odd_def_bal_id is
1053: select pdb.defined_balance_id
1054: from pay_balance_types pbt,
1055: pay_defined_balances pdb,
1056: pay_balance_dimensions pbd
1057: where pbt.balance_type_id = pdb.balance_type_id
1058: and pdb.balance_dimension_id = pbd.balance_dimension_id
1059: and pbt.balance_name = 'Addl Pasg Odd Taxable Amt'
1060: and pbd.dimension_name = '_ASG_YTD';

Line 1066: pay_balance_dimensions pbd

1062: cursor csr_get_even_def_bal_id is
1063: select pdb.defined_balance_id
1064: from pay_balance_types pbt,
1065: pay_defined_balances pdb,
1066: pay_balance_dimensions pbd
1067: where pbt.balance_type_id = pdb.balance_type_id
1068: and pdb.balance_dimension_id = pbd.balance_dimension_id
1069: and pbt.balance_name = 'Addl Pasg Even Taxable Amt'
1070: and pbd.dimension_name = '_ASG_YTD';