DBA Data[Home] [Help]

APPS.PAY_US_SQWL_UDF dependencies on PAY_BALANCE_DIMENSIONS

Line 638: CURSOR get_defined_balance_id(p_dimension_name pay_balance_dimensions.dimension_name%TYPE) IS

634: and pest.effective_end_date >= p_year_start_date
635: and pest.effective_start_date <= p_quarter_end_date
636: and pus.state_code=pest.state_code;
637:
638: CURSOR get_defined_balance_id(p_dimension_name pay_balance_dimensions.dimension_name%TYPE) IS
639: select pdb.defined_balance_id
640: from pay_balance_types pbt,
641: pay_balance_dimensions pbd,
642: pay_defined_balances pdb

Line 641: pay_balance_dimensions pbd,

637:
638: CURSOR get_defined_balance_id(p_dimension_name pay_balance_dimensions.dimension_name%TYPE) IS
639: select pdb.defined_balance_id
640: from pay_balance_types pbt,
641: pay_balance_dimensions pbd,
642: pay_defined_balances pdb
643: where pbt.legislation_code = 'US'
644: and pbt.balance_name = 'SUI ER Taxable'
645: and pbd.legislation_code = 'US'