APPS.PAY_US_SQWL_UDF dependencies on PAY_DEFINED_BALANCES

Line 642: pay_defined_balances pdb

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'
646: and pbd.dimension_name = p_dimension_name

Line 654: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;

650: l_person_id per_all_people_f.person_id%TYPE;
651: l_state_code pay_us_states.state_code%TYPE;
652: l_state_abbrev pay_us_states.state_abbrev%TYPE;
653: l_out_of_state_code pay_us_states.state_abbrev%TYPE;
654: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
655: l_year_start_date DATE;
656: l_quarter_start_date DATE;
657: l_quarter_end_date DATE;
658: l_effective_end_date DATE;