eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_BALANCE_FEEDS dependencies on PAY_BALANCE_FEEDS_F

Line 225: from pay_balance_feeds_f bf,

221: ) return boolean is
222: --
223: cursor csr_manual_feeds_exist is
224: select bf.balance_feed_id
225: from pay_balance_feeds_f bf,
226: pay_input_values_f inv,
227: pay_element_types_f elt,
228: pay_element_classifications ec
229: where bf.balance_type_id = p_balance_type_id

Line 415: from pay_balance_feeds_f bf

411: -- Get the start date of the earliest future balance feed if it exists.
412: begin
413: select min(bf.effective_start_date)
414: into v_next_bal_feed_start_date
415: from pay_balance_feeds_f bf
416: where bf.balance_type_id = p_balance_type_id
417: and bf.input_value_id = p_input_value_id
418: and bf.effective_end_date >= p_session_date
419: and bf.balance_feed_id <> nvl(p_balance_feed_id,0);

Line 496: insert into pay_balance_feeds_f

492: begin
493: --
494: -- Create a balance feed making sure that a balance feed does not already
495: -- exist.
496: insert into pay_balance_feeds_f
497: (balance_feed_id,
498: effective_start_date,
499: effective_end_date,
500: business_group_id,

Line 529: from pay_balance_feeds_f bf

525: trunc(sysdate)
526: from sys.dual
527: where not exists
528: (select null
529: from pay_balance_feeds_f bf
530: where bf.input_value_id = p_input_value_id
531: and bf.balance_type_id = p_balance_type_id
532: and p_effective_start_date <= bf.effective_end_date
533: and p_effective_end_date >= bf.effective_start_date

Line 785: from pay_balance_feeds_f bf,

781: (
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

Line 818: update pay_balance_feeds_f bf

814: for v_bf_rec in csr_bal_feeds_bal_class(p_balance_classification_id) loop
815: --
816: if p_mode = 'UPDATE' then
817: --
818: update pay_balance_feeds_f bf
819: set bf.scale = p_scale
820: where bf.rowid = v_bf_rec.row_id;
821: --
822: elsif p_mode = 'DELETE' then

Line 824: delete from pay_balance_feeds_f bf

820: where bf.rowid = v_bf_rec.row_id;
821: --
822: elsif p_mode = 'DELETE' then
823: --
824: delete from pay_balance_feeds_f bf
825: where bf.rowid = v_bf_rec.row_id;
826: --
827: else
828: --

Line 1170: from pay_balance_feeds_f bf,

1166: (
1167: p_input_value_id number
1168: ) is
1169: select bf.rowid row_id
1170: from pay_balance_feeds_f bf,
1171: pay_balance_types bt
1172: where bf.input_value_id = p_input_value_id
1173: and bt.balance_type_id = bf.balance_type_id
1174: for update;

Line 1184: from pay_balance_feeds_f bf,

1180: p_input_value_id number,
1181: p_validation_start_date date
1182: ) is
1183: select bf.rowid row_id
1184: from pay_balance_feeds_f bf,
1185: pay_balance_types bt
1186: where bf.input_value_id = p_input_value_id
1187: and bf.effective_start_date >= p_validation_start_date
1188: and bt.balance_type_id = bf.balance_type_id

Line 1199: from pay_balance_feeds_f bf,

1195: p_input_value_id number,
1196: p_validation_start_date date
1197: ) is
1198: select bf.rowid row_id
1199: from pay_balance_feeds_f bf,
1200: pay_balance_types bt
1201: where bf.input_value_id = p_input_value_id
1202: and bf.effective_end_date >= p_validation_start_date
1203: and bt.balance_type_id = bf.balance_type_id

Line 1214: from pay_balance_feeds_f bf,

1210: (
1211: p_input_value_id number
1212: ) is
1213: select bf.rowid row_id
1214: from pay_balance_feeds_f bf,
1215: pay_balance_types bt
1216: where bf.input_value_id = p_input_value_id
1217: and bt.balance_type_id = bf.balance_type_id
1218: and bf.effective_end_date =

Line 1220: from pay_balance_feeds_f bf2

1216: where bf.input_value_id = p_input_value_id
1217: and bt.balance_type_id = bf.balance_type_id
1218: and bf.effective_end_date =
1219: (select max(bf2.effective_end_date)
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

Line 1237: delete from pay_balance_feeds_f bf

1233: --
1234: for v_bf_rec in csr_bal_feeds_zap
1235: (p_input_value_id) loop
1236: --
1237: delete from pay_balance_feeds_f bf
1238: where bf.rowid = v_bf_rec.row_id;
1239: --
1240: end loop;
1241: --

Line 1252: delete from pay_balance_feeds_f bf

1248: for v_bf_rec in csr_bal_feeds_delete
1249: (p_input_value_id,
1250: p_validation_start_date) loop
1251: --
1252: delete from pay_balance_feeds_f bf
1253: where bf.rowid = v_bf_rec.row_id;
1254: --
1255: end loop;
1256: --

Line 1261: update pay_balance_feeds_f bf

1257: for v_bf_rec in csr_bal_feeds_update
1258: (p_input_value_id,
1259: p_validation_start_date) loop
1260: --
1261: update pay_balance_feeds_f bf
1262: set bf.effective_end_date = p_validation_start_date - 1
1263: where bf.rowid = v_bf_rec.row_id;
1264: --
1265: end loop;

Line 1282: update pay_balance_feeds_f bf

1278: --
1279: for v_bf_rec in csr_bal_feeds_extend
1280: (p_input_value_id) loop
1281: --
1282: update pay_balance_feeds_f bf
1283: set bf.effective_end_date = p_validation_end_date
1284: where bf.rowid = v_bf_rec.row_id;
1285: --
1286: end loop;

Line 1335: pay_balance_feeds_f bf,

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

Line 1372: delete from pay_balance_feeds_f bf

1368: for v_bf_rec in csr_bal_feeds_sub_class_rule
1369: (p_sub_classification_rule_id,
1370: v_pay_value_name) loop
1371: --
1372: delete from pay_balance_feeds_f bf
1373: where bf.rowid = v_bf_rec.row_id;
1374: --
1375: end loop;
1376: --

Line 1386: update pay_balance_feeds_f bf

1382: for v_bf_rec in csr_bal_feeds_sub_class_rule
1383: (p_sub_classification_rule_id,
1384: v_pay_value_name) loop
1385: --
1386: update pay_balance_feeds_f bf
1387: set bf.effective_end_date = p_validation_start_date - 1
1388: where bf.rowid = v_bf_rec.row_id;
1389: --
1390: end loop;

Line 1402: update pay_balance_feeds_f bf

1398: for v_bf_rec in csr_bal_feeds_sub_class_rule
1399: (p_sub_classification_rule_id,
1400: v_pay_value_name) loop
1401: --
1402: update pay_balance_feeds_f bf
1403: set bf.effective_end_date = p_validation_end_date
1404: where bf.rowid = v_bf_rec.row_id;
1405: --
1406: end loop;

Line 1547: from pay_balance_feeds_f bf,

1543: (
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

Line 1662: pay_balance_feeds_f bf,

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

Line 1819: from pay_balance_feeds_f

1815: else
1816: /* Bug 12770789, ends here*/
1817: select distinct input_value_id
1818: into v_iv_id
1819: from pay_balance_feeds_f
1820: where balance_feed_id = p_balance_feed_id;
1821: --
1822: open csr_bal_feed
1823: (v_iv_id,