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_TYPES

Line 448: pay_balance_types pbt,

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)
452: OR (pbt.legislation_code IS NOT NULL AND pbt.legislation_code = l_legislation_code))

Line 476: pay_balance_types pbt,

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)
480: OR (pbt.legislation_code IS NOT NULL AND pbt.legislation_code = l_legislation_code))

Line 503: pay_balance_types pbt,

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)
507: OR (pbt.legislation_code IS NOT NULL AND pbt.legislation_code = l_legislation_code))

Line 529: pay_balance_types pbt,

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)
533: OR (pbt.legislation_code IS NOT NULL AND pbt.legislation_code = l_legislation_code))

Line 678: ,pay_balance_types pbt

674: ,pay_balance_feeds_f pbf
675: ,pay_element_types_f pet2
676: ,pay_element_classifications pec
677: ,pay_input_values_f piv
678: ,pay_balance_types pbt
679: WHERE ec.classification_name = 'Balance Initialization'
680: AND ec.legislation_code IS NULL
681: AND ee.assignment_id = p_assignment_id
682: AND ee.element_link_id = el.element_link_id

Line 722: ,pay_balance_types pbt

718: ,pay_balance_feeds_f pbf
719: ,pay_element_types_f pet2
720: ,pay_element_classifications pec
721: ,pay_input_values_f piv
722: ,pay_balance_types pbt
723: WHERE ec.classification_name = 'Balance Initialization'
724: AND ec.legislation_code IS NULL
725: AND ee.assignment_id = p_assignment_id
726: AND ee.element_link_id = el.element_link_id