APPS.HR_US_FF_UDF1 dependencies on PAY_DEFINED_BALANCES

Line 4823: FROM pay_defined_balances pdb,

4819:
4820: CURSOR csr_defined_balance_id(p_balance_name IN VARCHAR2
4821: ,p_database_item_suffix IN VARCHAR2) IS
4822: SELECT pdb.defined_balance_id, pbt.balance_type_id
4823: FROM pay_defined_balances pdb,
4824: pay_balance_types pbt,
4825: pay_balance_dimensions pbd
4826: WHERE pdb.balance_dimension_id = pbd.balance_dimension_id
4827: AND pdb.balance_type_id = pbt.balance_type_id

Line 4832: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

4828: AND pbt.balance_name = p_balance_name
4829: AND pbd.database_item_suffix = p_database_item_suffix
4830: AND pdb.legislation_code = 'US';
4831:
4832: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
4833: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
4834: l_state_flag VARCHAR2(1);
4835: l_state_tax_flag VARCHAR2(1);
4836: l_county_tax_flag VARCHAR2(1);