APPS.HR_BALANCE_FEEDS dependencies on PAY_SUB_CLASSIFICATION_RULES_F

Line 663: from pay_sub_classification_rules_f scr,

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

Line 804: from pay_sub_classification_rules_f scr,

800: and et.classification_id = bc.classification_id))
801: or (ec.parent_classification_id is not null and
802: exists
803: (select null
804: from pay_sub_classification_rules_f scr,
805: pay_input_values_f iv
806: where iv.input_value_id = bf.input_value_id
807: and scr.element_type_id = iv.element_type_id
808: and scr.classification_id = bc.classification_id)))

Line 938: pay_sub_classification_rules_f scr,

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

Line 1056: from pay_sub_classification_rules_f scr,

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

Line 1333: from pay_sub_classification_rules_f scr,

1329: p_sub_classification_rule_id number,
1330: p_pay_value_name varchar2
1331: ) is
1332: select bf.rowid row_id
1333: from pay_sub_classification_rules_f scr,
1334: pay_input_values_f iv,
1335: pay_balance_feeds_f bf,
1336: pay_balance_classifications bc,
1337: pay_balance_types bt

Line 1498: from pay_sub_classification_rules_f scr,

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

Line 1564: from pay_sub_classification_rules_f scr,

1560: and et.classification_id = bc.classification_id))
1561: or (ec.parent_classification_id is not null and
1562: exists
1563: (select null
1564: from pay_sub_classification_rules_f scr,
1565: pay_input_values_f iv
1566: where iv.input_value_id = bf.input_value_id
1567: and scr.element_type_id = iv.element_type_id
1568: and scr.classification_id = bc.classification_id)))

Line 1611: from pay_sub_classification_rules_f scr,

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

Line 1660: from pay_sub_classification_rules_f scr,

1656: p_validation_start_date date,
1657: p_validation_end_date date
1658: ) is
1659: select bf.balance_feed_id
1660: from pay_sub_classification_rules_f scr,
1661: pay_input_values_f iv,
1662: pay_balance_feeds_f bf,
1663: pay_balance_classifications bc
1664: where scr.sub_classification_rule_id = p_sub_classification_rule_id