APPS.PAY_GB_P11D_MILEAGE_EXTRACT dependencies on PAY_DEFINED_BALANCES

Line 898: l_def_bal_id pay_defined_balances.defined_balance_id%type;

894: l_ext_end_date date;
895:
896: l_ben_start_date date;
897:
898: l_def_bal_id pay_defined_balances.defined_balance_id%type;
899:
900: cursor csr_get_odd_def_bal_id is
901: select pdb.defined_balance_id
902: from pay_balance_types pbt,

Line 903: pay_defined_balances pdb,

899:
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'

Line 913: pay_defined_balances pdb,

909:
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'

Line 1050: l_def_bal_id pay_defined_balances.defined_balance_id%type;

1046: l_ext_end_date date;
1047:
1048: l_ben_start_date date;
1049:
1050: l_def_bal_id pay_defined_balances.defined_balance_id%type;
1051:
1052: cursor csr_get_odd_def_bal_id is
1053: select pdb.defined_balance_id
1054: from pay_balance_types pbt,

Line 1055: pay_defined_balances pdb,

1051:
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'

Line 1065: pay_defined_balances pdb,

1061:
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'