APPS.HR_BALANCES dependencies on PAY_BALANCE_FEEDS_S

Line 211: pay_balance_feeds_s.nextval a_balance_feed_id,

207: -- Declare local cursors
208: --
209: CURSOR cur_get_pay_pay_value IS
210: SELECT /*+ INDEX (BT PAY_BALANCE_TYPES_PK) */
211: pay_balance_feeds_s.nextval a_balance_feed_id,
212: iv.effective_start_date a_effective_start_date,
213: iv.effective_end_date a_effective_end_date,
214: iv.input_value_id a_input_value_id,
215: bc.balance_type_id a_balance_type_id,

Line 271: pay_balance_feeds_s.nextval a_balance_feed_id,

267: AND feed.effective_end_date >= iv.effective_start_date;
268: --
269: CURSOR cur_get_per_pay_value_prim IS
270: SELECT /*+ INDEX (BT PAY_BALANCE_TYPES_PK) */
271: pay_balance_feeds_s.nextval a_balance_feed_id,
272: iv.effective_start_date a_effective_start_date,
273: iv.effective_end_date a_effective_end_date,
274: iv.input_value_id a_input_value_id,
275: bc.balance_type_id a_balance_type_id,

Line 331: pay_balance_feeds_s.nextval a_balance_feed_id,

327: AND feed.effective_end_date >= iv.effective_start_date;
328: --
329: CURSOR cur_get_per_pay_value_sub IS
330: SELECT /*+ INDEX (BT PAY_BALANCE_TYPES_PK) */
331: pay_balance_feeds_s.nextval a_balance_feed_id,
332: scr.effective_start_date a_effective_start_date,
333: scr.effective_end_date a_effective_end_date,
334: iv.input_value_id a_input_value_id,
335: bc.balance_type_id a_balance_type_id,

Line 535: SELECT pay_balance_feeds_s.nextval a_balance_feed_id,

531: AND et.effective_end_date >= p_session_date;
532: --
533: CURSOR cur_bt_sub_class_rule (c_uom varchar2,
534: c_output_currency_code varchar2) IS
535: SELECT pay_balance_feeds_s.nextval a_balance_feed_id,
536: bc.balance_type_id a_balance_type_id,
537: bc.scale a_scale,
538: bc.last_updated_by a_last_updated_by,
539: bc.last_update_login a_last_update_login,

Line 1030: SELECT pay_balance_feeds_s.nextval

1026: IF p_session_date is not NULL THEN
1027: --
1028: hr_utility.set_location('INS_MANUAL_FEED', 4);
1029: --
1030: SELECT pay_balance_feeds_s.nextval
1031: INTO v_sequence
1032: FROM sys.dual;
1033: --
1034: INSERT INTO pay_balance_feeds_f

Line 1231: SELECT pay_balance_feeds_s.nextval

1227: --
1228: EXIT bal_loop WHEN iv_rec.a_effective_start_date IS NULL
1229: OR iv_rec.a_effective_end_date IS NULL;
1230: --
1231: SELECT pay_balance_feeds_s.nextval
1232: INTO v_sequence
1233: FROM sys.dual;
1234: --
1235: INSERT INTO pay_balance_feeds_f

Line 1316: SELECT pay_balance_feeds_s.nextval

1312: hr_utility.set_location('INS_SUB_BAL_CLASS', 4);
1313: --
1314: FOR iv_rec IN cur_iv_sub_bal_class LOOP
1315: --
1316: SELECT pay_balance_feeds_s.nextval
1317: INTO v_sequence
1318: FROM sys.dual;
1319: --
1320: INSERT INTO pay_balance_feeds_f

Line 1406: SELECT pay_balance_feeds_s.nextval

1402: IF p_session_date is not NULL THEN
1403: --
1404: hr_utility.set_location('INS_PRIMARY_BALANCE_FEED', 4);
1405: --
1406: SELECT pay_balance_feeds_s.nextval
1407: INTO v_sequence
1408: FROM sys.dual;
1409: --
1410: hr_utility.set_location('INS_PRIMARY_BALANCE_FEED', 5);