APPS.PAY_GB_P11D_MILEAGE_EXTRACT dependencies on PAY_BALANCE_TYPES

Line 902: from pay_balance_types pbt,

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,
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

Line 912: from pay_balance_types pbt,

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

Line 1054: from pay_balance_types pbt,

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,
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

Line 1064: from pay_balance_types pbt,

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