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.PAY_IP_EMPLOYEE_BALANCES dependencies on PAY_BALANCE_DIMENSIONS

Line 447: pay_balance_dimensions pbd,

443: pbt.balance_type_id,
444: pbd.balance_dimension_id,
445: pbd.database_item_suffix
446: FROM pay_defined_balances pdb_call,
447: pay_balance_dimensions pbd,
448: pay_balance_types pbt,
449: pay_element_types_f pet
450: WHERE pbt.balance_type_id = fnd_number.canonical_to_number(p_balance_type_id)
451: AND ((pbt.business_group_id IS NOT NULL AND pbt.business_group_id = p_business_group_id)

Line 475: pay_balance_dimensions pbd,

471: pbt.balance_type_id,
472: pbd.balance_dimension_id,
473: pbd.database_item_suffix
474: FROM pay_defined_balances pdb_call,
475: pay_balance_dimensions pbd,
476: pay_balance_types pbt,
477: pay_element_types_f pet
478: WHERE pbt.balance_type_id = fnd_number.canonical_to_number(p_balance_type_id)
479: AND ((pbt.business_group_id IS NOT NULL AND pbt.business_group_id = p_business_group_id)

Line 502: pay_balance_dimensions pbd,

498: pdb_call.defined_balance_id,
499: pbt.balance_type_id,
500: pbd.balance_dimension_id
501: FROM pay_defined_balances pdb_call,
502: pay_balance_dimensions pbd,
503: pay_balance_types pbt,
504: pay_element_types_f pet
505: WHERE pbt.balance_type_id = fnd_number.canonical_to_number(p_balance_type_id)
506: AND ((pbt.business_group_id IS NOT NULL AND pbt.business_group_id = p_business_group_id)

Line 528: pay_balance_dimensions pbd,

524: pdb_call.defined_balance_id,
525: pbt.balance_type_id,
526: pbd.balance_dimension_id
527: FROM pay_defined_balances pdb_call,
528: pay_balance_dimensions pbd,
529: pay_balance_types pbt,
530: pay_element_types_f pet
531: WHERE pbt.balance_type_id = fnd_number.canonical_to_number(p_balance_type_id)
532: AND ((pbt.business_group_id IS NOT NULL AND pbt.business_group_id = p_business_group_id)

Line 762: FROM pay_balance_dimensions

758: l_function :='get_defined_bal';
759: hr_utility.set_location(l_package||l_function, 10);
760:
761: SELECT balance_dimension_id INTO l_dim_id
762: FROM pay_balance_dimensions
763: WHERE database_item_suffix = p_dimension
764: AND legislation_code = l_legislation_code;
765:
766: SELECT defined_balance_id INTO l_defbal_id