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 146: from pay_balance_types bt

142: (
143: p_balance_type_id number
144: ) is
145: select bt.balance_type_id
146: from pay_balance_types bt
147: where bt.balance_type_id = p_balance_type_id
148: for update;
149: --
150: v_balance_type_id number;

Line 597: pay_balance_types bt,

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

Line 668: pay_balance_types bt,

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

Line 787: pay_balance_types bt,

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

Line 872: from pay_balance_types bt,

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

Line 936: pay_balance_types bt,

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

Line 1060: pay_balance_types bt,

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

Line 1171: pay_balance_types bt

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;
1175: --

Line 1185: pay_balance_types bt

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
1189: for update;

Line 1200: pay_balance_types bt

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
1204: for update;

Line 1215: pay_balance_types bt

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 =
1219: (select max(bf2.effective_end_date)

Line 1337: pay_balance_types bt

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

Line 1457: pay_balance_types bt,

1453: max(iv.effective_end_date) effective_end_date
1454: from pay_input_values_f iv,
1455: pay_element_types_f et,
1456: pay_element_classifications ec,
1457: pay_balance_types bt,
1458: per_business_groups_perf ivbg,
1459: per_business_groups_perf btbg
1460: where bt.balance_type_id = p_balance_type_id
1461: and ec.classification_id = p_classification_id

Line 1502: pay_balance_types bt,

1498: from pay_sub_classification_rules_f scr,
1499: pay_element_types_f et,
1500: pay_input_values_f iv,
1501: pay_element_classifications ec,
1502: pay_balance_types bt,
1503: per_business_groups_perf ivbg,
1504: per_business_groups_perf btbg
1505: where bt.balance_type_id = p_balance_type_id
1506: and ec.classification_id = p_classification_id

Line 1615: pay_balance_types bt,

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