DBA Data[Home] [Help]

APPS.HR_US_FF_UDF1 dependencies on PAY_DEFINED_BALANCES

Line 5010: FROM pay_defined_balances pdb,

5006:
5007: CURSOR csr_defined_balance_id(p_balance_name IN VARCHAR2
5008: ,p_database_item_suffix IN VARCHAR2) IS
5009: SELECT pdb.defined_balance_id, pbt.balance_type_id
5010: FROM pay_defined_balances pdb,
5011: pay_balance_types pbt,
5012: pay_balance_dimensions pbd
5013: WHERE pdb.balance_dimension_id = pbd.balance_dimension_id
5014: AND pdb.balance_type_id = pbt.balance_type_id

Line 5019: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

5015: AND pbt.balance_name = p_balance_name
5016: AND pbd.database_item_suffix = p_database_item_suffix
5017: AND pdb.legislation_code = 'US';
5018:
5019: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
5020: l_balance_type_id pay_balance_types.balance_type_id%TYPE;
5021: l_state_flag VARCHAR2(1);
5022: l_state_tax_flag VARCHAR2(1);
5023: l_county_tax_flag VARCHAR2(1);