APPS.HR_BALANCE_FEEDS dependencies on PAY_BALANCE_CLASSIFICATIONS

Line 180: from pay_balance_classifications bcl

176: ) return boolean is
177: --
178: cursor csr_classifications_exist is
179: select bcl.classification_id
180: from pay_balance_classifications bcl
181: where bcl.balance_type_id = p_balance_type_id;
182: --
183: v_classification_id number;
184: --

Line 228: from pay_balance_classifications bc

224: and elt.classification_id = ec.classification_id
225: and nvl(ec.balance_initialization_flag,'N') = 'N'
226: and not exists
227: (select null
228: from pay_balance_classifications bc
229: where bc.balance_type_id = bf.balance_type_id);
230: --
231: v_bal_feed_id number;
232: --

Line 586: pay_balance_classifications bc,

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,
589: per_business_groups_perf btbg
590: where bc.balance_classification_id = p_balance_classification_id

Line 657: pay_balance_classifications bc,

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,
659: per_business_groups_perf ivbg,
660: per_business_groups_perf btbg
661: where bc.balance_classification_id = p_balance_classification_id

Line 776: pay_balance_classifications bc,

772: p_balance_classification_id number
773: ) is
774: select bf.rowid row_id
775: from pay_balance_feeds_f bf,
776: pay_balance_classifications bc,
777: pay_balance_types bt,
778: pay_element_classifications ec
779: where bc.balance_classification_id = p_balance_classification_id
780: and bt.balance_type_id = bc.balance_type_id

Line 863: pay_balance_classifications bc,

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

Line 925: pay_balance_classifications bc,

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

Line 1049: pay_balance_classifications bc,

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

Line 1214: from pay_balance_classifications bc

1210: from pay_balance_feeds_f bf2
1211: where bf2.balance_feed_id = bf.balance_feed_id)
1212: and exists
1213: (select null
1214: from pay_balance_classifications bc
1215: where bc.balance_type_id = bf.balance_type_id)
1216: for update;
1217: --
1218: begin

Line 1326: pay_balance_classifications bc,

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
1328: where scr.sub_classification_rule_id = p_sub_classification_rule_id
1329: and iv.element_type_id = scr.element_type_id
1330: and iv.name = p_pay_value_name

Line 1538: pay_balance_classifications bc,

1534: p_balance_classification_id number
1535: ) is
1536: select bf.balance_feed_id
1537: from pay_balance_feeds_f bf,
1538: pay_balance_classifications bc,
1539: pay_element_classifications ec
1540: where bc.balance_classification_id = p_balance_classification_id
1541: and bf.balance_type_id = bc.balance_type_id
1542: and ec.classification_id = bc.classification_id

Line 1604: pay_balance_classifications bc,

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

Line 1653: pay_balance_classifications bc

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
1655: and iv.element_type_id = scr.element_type_id
1656: and bc.classification_id = scr.classification_id
1657: and bf.balance_type_id = bc.balance_type_id