APPS.HR_BALANCE_FEEDS dependencies on PAY_ELEMENT_TYPES_F

Line 219: pay_element_types_f elt,

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

Line 584: pay_element_types_f et,

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

Line 654: pay_element_types_f et,

650: ,bt.balance_name
651: ,ec.classification_name
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,

Line 786: from pay_element_types_f et,

782: and ec.classification_id = bc.classification_id
783: and ((ec.parent_classification_id is null and
784: exists
785: (select null
786: from pay_element_types_f et,
787: pay_input_values_f iv
788: where iv.input_value_id = bf.input_value_id
789: and et.element_type_id = iv.element_type_id
790: and et.classification_id = bc.classification_id))

Line 864: pay_element_types_f et,

860: null, nvl(iv.legislation_code,bt.legislation_code),
861: null) legislation_code
862: from pay_balance_types bt,
863: pay_balance_classifications bc,
864: pay_element_types_f et,
865: pay_input_values_f iv,
866: per_business_groups_perf ivbg,
867: per_business_groups_perf btbg
868: where iv.input_value_id = p_input_value_id

Line 927: pay_element_types_f et,

923: null) legislation_code
924: from pay_input_values_f iv,
925: pay_balance_classifications bc,
926: pay_balance_types bt,
927: pay_element_types_f et,
928: pay_sub_classification_rules_f scr,
929: per_business_groups_perf ivbg,
930: per_business_groups_perf btbg
931: where iv.input_value_id = p_input_value_id

Line 1047: pay_element_types_f et,

1043: nvl(scr.legislation_code,
1044: bt.legislation_code)),
1045: null) legislation_code
1046: from pay_sub_classification_rules_f scr,
1047: pay_element_types_f et,
1048: pay_input_values_f iv,
1049: pay_balance_classifications bc,
1050: pay_balance_types bt,
1051: per_business_groups_perf ivbg,

Line 1445: pay_element_types_f et,

1441: select iv.input_value_id,
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

Line 1489: pay_element_types_f et,

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

Line 1546: from pay_element_types_f et,

1542: and ec.classification_id = bc.classification_id
1543: and ((ec.parent_classification_id is null and
1544: exists
1545: (select null
1546: from pay_element_types_f et,
1547: pay_input_values_f iv
1548: where iv.input_value_id = bf.input_value_id
1549: and et.element_type_id = iv.element_type_id
1550: and et.classification_id = bc.classification_id))

Line 1602: pay_element_types_f et,

1598: select iv.input_value_id,
1599: scr.effective_start_date,
1600: scr.effective_end_date
1601: from pay_sub_classification_rules_f scr,
1602: pay_element_types_f et,
1603: pay_input_values_f iv,
1604: pay_balance_classifications bc,
1605: pay_balance_types bt,
1606: per_business_groups_perf ivbg,