eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_US_FF_UDF1 dependencies on PAY_BALANCE_TYPES

Line 5011: pay_balance_types pbt,

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
5015: AND pbt.balance_name = p_balance_name

Line 5020: l_balance_type_id pay_balance_types.balance_type_id%TYPE;

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);
5024: l_city_tax_flag VARCHAR2(1);

Line 6507: FROM pay_balance_types

6503: RETURN NUMBER IS
6504:
6505: CURSOR get_balance_type_id IS
6506: SELECT balance_type_id
6507: FROM pay_balance_types
6508: WHERE balance_name = 'Head Tax Withheld'
6509: AND legislation_code = 'US';
6510:
6511: CURSOR get_value (p_asgmnt_action_id NUMBER,

Line 6516: ,pay_balance_types BAL

6512: p_jurisdiction_code VARCHAR2,
6513: p_balance_type_id NUMBER) IS
6514: SELECT /*+ RULE*/ nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0)
6515: FROM pay_run_result_values TARGET
6516: ,pay_balance_types BAL
6517: ,pay_balance_feeds_f FEED
6518: ,pay_run_results RR
6519: ,pay_assignment_actions ASSACT
6520: ,pay_assignment_actions BAL_ASSACT