APPS.HR_BALANCE_FEEDS dependencies on PAY_SUB_CLASSIFICATION_RULES_F

Line 653: from pay_sub_classification_rules_f scr,

649: null) legislation_code
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,

Line 794: from pay_sub_classification_rules_f scr,

790: and et.classification_id = bc.classification_id))
791: or (ec.parent_classification_id is not null and
792: exists
793: (select null
794: from pay_sub_classification_rules_f scr,
795: pay_input_values_f iv
796: where iv.input_value_id = bf.input_value_id
797: and scr.element_type_id = iv.element_type_id
798: and scr.classification_id = bc.classification_id)))

Line 928: pay_sub_classification_rules_f scr,

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
932: and et.element_type_id = iv.element_type_id

Line 1046: from pay_sub_classification_rules_f scr,

1042: null, nvl(iv.legislation_code,
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,

Line 1323: from pay_sub_classification_rules_f scr,

1319: p_sub_classification_rule_id number,
1320: p_pay_value_name varchar2
1321: ) is
1322: select bf.rowid row_id
1323: from pay_sub_classification_rules_f scr,
1324: pay_input_values_f iv,
1325: pay_balance_feeds_f bf,
1326: pay_balance_classifications bc,
1327: pay_balance_types bt

Line 1488: from pay_sub_classification_rules_f scr,

1484: union
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,

Line 1554: from pay_sub_classification_rules_f scr,

1550: and et.classification_id = bc.classification_id))
1551: or (ec.parent_classification_id is not null and
1552: exists
1553: (select null
1554: from pay_sub_classification_rules_f scr,
1555: pay_input_values_f iv
1556: where iv.input_value_id = bf.input_value_id
1557: and scr.element_type_id = iv.element_type_id
1558: and scr.classification_id = bc.classification_id)))

Line 1601: from pay_sub_classification_rules_f scr,

1597: ) is
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,

Line 1650: from pay_sub_classification_rules_f scr,

1646: p_validation_start_date date,
1647: p_validation_end_date date
1648: ) is
1649: select bf.balance_feed_id
1650: from pay_sub_classification_rules_f scr,
1651: pay_input_values_f iv,
1652: pay_balance_feeds_f bf,
1653: pay_balance_classifications bc
1654: where scr.sub_classification_rule_id = p_sub_classification_rule_id