APPS.HR_BALANCE_FEEDS dependencies on PAY_BALANCE_CLASSIFICATIONS

Line 188: from pay_balance_classifications bcl

184: ) return boolean is
185: --
186: cursor csr_classifications_exist is
187: select bcl.classification_id
188: from pay_balance_classifications bcl
189: where bcl.balance_type_id = p_balance_type_id;
190: --
191: v_classification_id number;
192: --

Line 236: from pay_balance_classifications bc

232: and elt.classification_id = ec.classification_id
233: and nvl(ec.balance_initialization_flag,'N') = 'N'
234: and not exists
235: (select null
236: from pay_balance_classifications bc
237: where bc.balance_type_id = bf.balance_type_id);
238: --
239: v_bal_feed_id number;
240: --

Line 596: pay_balance_classifications bc,

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
600: where bc.balance_classification_id = p_balance_classification_id

Line 667: pay_balance_classifications bc,

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
671: where bc.balance_classification_id = p_balance_classification_id

Line 786: pay_balance_classifications bc,

782: p_balance_classification_id number
783: ) is
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

Line 873: pay_balance_classifications bc,

869: decode(nvl(iv.business_group_id,bt.business_group_id),
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

Line 935: pay_balance_classifications bc,

931: nvl(scr.legislation_code,
932: bt.legislation_code)),
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,

Line 1059: pay_balance_classifications bc,

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,
1062: per_business_groups_perf btbg
1063: where scr.sub_classification_rule_id = p_sub_classification_rule_id

Line 1224: from pay_balance_classifications bc

1220: from pay_balance_feeds_f bf2
1221: where bf2.balance_feed_id = bf.balance_feed_id)
1222: and exists
1223: (select null
1224: from pay_balance_classifications bc
1225: where bc.balance_type_id = bf.balance_type_id)
1226: for update;
1227: --
1228: begin

Line 1336: pay_balance_classifications bc,

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
1338: where scr.sub_classification_rule_id = p_sub_classification_rule_id
1339: and iv.element_type_id = scr.element_type_id
1340: and iv.name = p_pay_value_name

Line 1548: pay_balance_classifications bc,

1544: p_balance_classification_id number
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

Line 1614: pay_balance_classifications bc,

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,
1617: per_business_groups_perf btbg
1618: where bc.classification_id = p_classification_id

Line 1663: pay_balance_classifications bc

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
1665: and iv.element_type_id = scr.element_type_id
1666: and bc.classification_id = scr.classification_id
1667: and bf.balance_type_id = bc.balance_type_id