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_TYPES

Line 138: from pay_balance_types bt

134: (
135: p_balance_type_id number
136: ) is
137: select bt.balance_type_id
138: from pay_balance_types bt
139: where bt.balance_type_id = p_balance_type_id
140: for update;
141: --
142: v_balance_type_id number;

Line 587: pay_balance_types bt,

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
591: and ec.classification_id = bc.classification_id

Line 658: pay_balance_types bt,

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
662: and ec.classification_id = bc.classification_id

Line 777: pay_balance_types bt,

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
781: and bf.balance_type_id = bt.balance_type_id

Line 862: from pay_balance_types bt,

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

Line 926: pay_balance_types bt,

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,
930: per_business_groups_perf btbg

Line 1050: pay_balance_types bt,

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
1054: and bc.classification_id = scr.classification_id

Line 1161: pay_balance_types bt

1157: p_input_value_id number
1158: ) is
1159: select bf.rowid row_id
1160: from pay_balance_feeds_f bf,
1161: pay_balance_types bt
1162: where bf.input_value_id = p_input_value_id
1163: and bt.balance_type_id = bf.balance_type_id
1164: for update;
1165: --

Line 1175: pay_balance_types bt

1171: p_validation_start_date date
1172: ) is
1173: select bf.rowid row_id
1174: from pay_balance_feeds_f bf,
1175: pay_balance_types bt
1176: where bf.input_value_id = p_input_value_id
1177: and bf.effective_start_date >= p_validation_start_date
1178: and bt.balance_type_id = bf.balance_type_id
1179: for update;

Line 1190: pay_balance_types bt

1186: p_validation_start_date date
1187: ) is
1188: select bf.rowid row_id
1189: from pay_balance_feeds_f bf,
1190: pay_balance_types bt
1191: where bf.input_value_id = p_input_value_id
1192: and bf.effective_end_date >= p_validation_start_date
1193: and bt.balance_type_id = bf.balance_type_id
1194: for update;

Line 1205: pay_balance_types bt

1201: p_input_value_id number
1202: ) is
1203: select bf.rowid row_id
1204: from pay_balance_feeds_f bf,
1205: pay_balance_types bt
1206: where bf.input_value_id = p_input_value_id
1207: and bt.balance_type_id = bf.balance_type_id
1208: and bf.effective_end_date =
1209: (select max(bf2.effective_end_date)

Line 1327: pay_balance_types bt

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
1331: and bc.classification_id = scr.classification_id

Line 1447: pay_balance_types bt,

1443: max(iv.effective_end_date) effective_end_date
1444: from pay_input_values_f iv,
1445: pay_element_types_f et,
1446: pay_element_classifications ec,
1447: pay_balance_types bt,
1448: per_business_groups_perf ivbg,
1449: per_business_groups_perf btbg
1450: where bt.balance_type_id = p_balance_type_id
1451: and ec.classification_id = p_classification_id

Line 1492: pay_balance_types bt,

1488: from pay_sub_classification_rules_f scr,
1489: pay_element_types_f et,
1490: pay_input_values_f iv,
1491: pay_element_classifications ec,
1492: pay_balance_types bt,
1493: per_business_groups_perf ivbg,
1494: per_business_groups_perf btbg
1495: where bt.balance_type_id = p_balance_type_id
1496: and ec.classification_id = p_classification_id

Line 1605: pay_balance_types bt,

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
1609: and bt.balance_type_id = bc.balance_type_id