[Home] [Help]
224: select bf.balance_feed_id
225: from pay_balance_feeds_f bf,
226: pay_input_values_f inv,
227: pay_element_types_f elt,
228: pay_element_classifications ec
229: where bf.balance_type_id = p_balance_type_id
230: and bf.input_value_id = inv.input_value_id
231: and inv.element_type_id = elt.element_type_id
232: and elt.classification_id = ec.classification_id
354: -- Check to see if classification is primary or secondary.
355: begin
356: select ecl.parent_classification_id
357: into v_parent_classification_id
358: from pay_element_classifications ecl
359: where ecl.classification_id = p_classification_id;
360: exception
361: when no_data_found then
362: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
591: ,ec.classification_name
592: ,et.element_name
593: from pay_input_values_f iv,
594: pay_element_types_f et,
595: pay_element_classifications ec,
596: pay_balance_classifications bc,
597: pay_balance_types bt,
598: per_business_groups_perf ivbg,
599: per_business_groups_perf btbg
662: ,et.element_name
663: from pay_sub_classification_rules_f scr,
664: pay_element_types_f et,
665: pay_input_values_f iv,
666: pay_element_classifications ec,
667: pay_balance_classifications bc,
668: pay_balance_types bt,
669: per_business_groups_perf ivbg,
670: per_business_groups_perf btbg
784: select bf.rowid row_id
785: from pay_balance_feeds_f bf,
786: pay_balance_classifications bc,
787: pay_balance_types bt,
788: pay_element_classifications ec
789: where bc.balance_classification_id = p_balance_classification_id
790: and bt.balance_type_id = bc.balance_type_id
791: and bf.balance_type_id = bt.balance_type_id
792: and ec.classification_id = bc.classification_id
1452: min(iv.effective_start_date) effective_start_date,
1453: max(iv.effective_end_date) effective_end_date
1454: from pay_input_values_f iv,
1455: pay_element_types_f et,
1456: pay_element_classifications ec,
1457: pay_balance_types bt,
1458: per_business_groups_perf ivbg,
1459: per_business_groups_perf btbg
1460: where bt.balance_type_id = p_balance_type_id
1497: scr.effective_end_date
1498: from pay_sub_classification_rules_f scr,
1499: pay_element_types_f et,
1500: pay_input_values_f iv,
1501: pay_element_classifications ec,
1502: pay_balance_types bt,
1503: per_business_groups_perf ivbg,
1504: per_business_groups_perf btbg
1505: where bt.balance_type_id = p_balance_type_id
1545: ) is
1546: select bf.balance_feed_id
1547: from pay_balance_feeds_f bf,
1548: pay_balance_classifications bc,
1549: pay_element_classifications ec
1550: where bc.balance_classification_id = p_balance_classification_id
1551: and bf.balance_type_id = bc.balance_type_id
1552: and ec.classification_id = bc.classification_id
1553: and ((ec.parent_classification_id is null and