DBA Data[Home] [Help]

APPS.PAY_US_SQWL_UDF dependencies on PAY_BALANCE_TYPES

Line 590: pay_balance_types pbt,

586: pay_element_entries_f pee,
587: pay_element_entry_values_f peev,
588: pay_input_values_f piv1,
589: pay_input_values_f piv2,
590: pay_balance_types pbt,
591: pay_balance_feeds_f pbf,
592: pay_element_links_f pel,
593: pay_us_states pus
594: where paaf.person_id=p_person_id

Line 640: from pay_balance_types pbt,

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
643: where pbt.legislation_code = 'US'
644: and pbt.balance_name = 'SUI ER Taxable'