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_BALANCE_FEEDS dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 220: pay_element_classifications ec

216: select bf.balance_feed_id
217: from pay_balance_feeds_f bf,
218: pay_input_values_f inv,
219: pay_element_types_f elt,
220: pay_element_classifications ec
221: where bf.balance_type_id = p_balance_type_id
222: and bf.input_value_id = inv.input_value_id
223: and inv.element_type_id = elt.element_type_id
224: and elt.classification_id = ec.classification_id

Line 350: from pay_element_classifications ecl

346: -- Check to see if classification is primary or secondary.
347: begin
348: select ecl.parent_classification_id
349: into v_parent_classification_id
350: from pay_element_classifications ecl
351: where ecl.classification_id = p_classification_id;
352: exception
353: when no_data_found then
354: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

Line 585: pay_element_classifications ec,

581: ,ec.classification_name
582: ,et.element_name
583: from pay_input_values_f iv,
584: pay_element_types_f et,
585: pay_element_classifications ec,
586: pay_balance_classifications bc,
587: pay_balance_types bt,
588: per_business_groups_perf ivbg,
589: per_business_groups_perf btbg

Line 656: pay_element_classifications ec,

652: ,et.element_name
653: from pay_sub_classification_rules_f scr,
654: pay_element_types_f et,
655: pay_input_values_f iv,
656: pay_element_classifications ec,
657: pay_balance_classifications bc,
658: pay_balance_types bt,
659: per_business_groups_perf ivbg,
660: per_business_groups_perf btbg

Line 778: pay_element_classifications ec

774: select bf.rowid row_id
775: from pay_balance_feeds_f bf,
776: pay_balance_classifications bc,
777: pay_balance_types bt,
778: pay_element_classifications ec
779: where bc.balance_classification_id = p_balance_classification_id
780: and bt.balance_type_id = bc.balance_type_id
781: and bf.balance_type_id = bt.balance_type_id
782: and ec.classification_id = bc.classification_id

Line 1446: pay_element_classifications ec,

1442: min(iv.effective_start_date) effective_start_date,
1443: max(iv.effective_end_date) effective_end_date
1444: from pay_input_values_f iv,
1445: pay_element_types_f et,
1446: pay_element_classifications ec,
1447: pay_balance_types bt,
1448: per_business_groups_perf ivbg,
1449: per_business_groups_perf btbg
1450: where bt.balance_type_id = p_balance_type_id

Line 1491: pay_element_classifications ec,

1487: scr.effective_end_date
1488: from pay_sub_classification_rules_f scr,
1489: pay_element_types_f et,
1490: pay_input_values_f iv,
1491: pay_element_classifications ec,
1492: pay_balance_types bt,
1493: per_business_groups_perf ivbg,
1494: per_business_groups_perf btbg
1495: where bt.balance_type_id = p_balance_type_id

Line 1539: pay_element_classifications ec

1535: ) is
1536: select bf.balance_feed_id
1537: from pay_balance_feeds_f bf,
1538: pay_balance_classifications bc,
1539: pay_element_classifications ec
1540: where bc.balance_classification_id = p_balance_classification_id
1541: and bf.balance_type_id = bc.balance_type_id
1542: and ec.classification_id = bc.classification_id
1543: and ((ec.parent_classification_id is null and