APPS.HR_BALANCE_FEEDS dependencies on PAY_ELEMENT_TYPES_F

Line 227: pay_element_types_f elt,

223: cursor csr_manual_feeds_exist is
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

Line 594: pay_element_types_f et,

590: ,bt.balance_name
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,

Line 664: pay_element_types_f et,

660: ,bt.balance_name
661: ,ec.classification_name
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,

Line 796: from pay_element_types_f et,

792: and ec.classification_id = bc.classification_id
793: and ((ec.parent_classification_id is null and
794: exists
795: (select null
796: from pay_element_types_f et,
797: pay_input_values_f iv
798: where iv.input_value_id = bf.input_value_id
799: and et.element_type_id = iv.element_type_id
800: and et.classification_id = bc.classification_id))

Line 874: pay_element_types_f et,

870: null, nvl(iv.legislation_code,bt.legislation_code),
871: null) legislation_code
872: from pay_balance_types bt,
873: pay_balance_classifications bc,
874: pay_element_types_f et,
875: pay_input_values_f iv,
876: per_business_groups_perf ivbg,
877: per_business_groups_perf btbg
878: where iv.input_value_id = p_input_value_id

Line 937: pay_element_types_f et,

933: null) legislation_code
934: from pay_input_values_f iv,
935: pay_balance_classifications bc,
936: pay_balance_types bt,
937: pay_element_types_f et,
938: pay_sub_classification_rules_f scr,
939: per_business_groups_perf ivbg,
940: per_business_groups_perf btbg
941: where iv.input_value_id = p_input_value_id

Line 1057: pay_element_types_f et,

1053: nvl(scr.legislation_code,
1054: bt.legislation_code)),
1055: null) legislation_code
1056: from pay_sub_classification_rules_f scr,
1057: pay_element_types_f et,
1058: pay_input_values_f iv,
1059: pay_balance_classifications bc,
1060: pay_balance_types bt,
1061: per_business_groups_perf ivbg,

Line 1455: pay_element_types_f et,

1451: select iv.input_value_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

Line 1499: pay_element_types_f et,

1495: select iv.input_value_id,
1496: scr.effective_start_date,
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,

Line 1556: from pay_element_types_f et,

1552: and ec.classification_id = bc.classification_id
1553: and ((ec.parent_classification_id is null and
1554: exists
1555: (select null
1556: from pay_element_types_f et,
1557: pay_input_values_f iv
1558: where iv.input_value_id = bf.input_value_id
1559: and et.element_type_id = iv.element_type_id
1560: and et.classification_id = bc.classification_id))

Line 1612: pay_element_types_f et,

1608: select iv.input_value_id,
1609: scr.effective_start_date,
1610: scr.effective_end_date
1611: from pay_sub_classification_rules_f scr,
1612: pay_element_types_f et,
1613: pay_input_values_f iv,
1614: pay_balance_classifications bc,
1615: pay_balance_types bt,
1616: per_business_groups_perf ivbg,