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_BALANCES dependencies on PAY_BALANCE_TYPES

Line 35: PAY_BALANCE_TYPES

31: PAY_ELEMENT_TYPES_F
32: PAY_INPUT_VALUES_F
33: PAY_SUB_CLASSIFICATION_RULES_F
34: PAY_BALANCE_FEEDS_F
35: PAY_BALANCE_TYPES
36: PAY_BALANCE_CLASSIFCIATIONS
37: PAY_DEFINED_BALANCES
38: --
39: Uses : hr_utility

Line 210: SELECT /+ INDEX (BT PAY_BALANCE_TYPES_PK) /

206: --
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,

Line 223: FROM pay_balance_types bt,

219: iv.legislation_subgroup a_legislation_subgroup,
220: iv.last_updated_by a_last_updated_by,
221: iv.last_update_login a_last_update_login,
222: iv.created_by a_created_by
223: FROM pay_balance_types bt,
224: pay_balance_classifications bc,
225: pay_element_types_f et,
226: pay_input_values_f iv
227: WHERE iv.input_value_id = p_input_value_id

Line 246: pay_balance_types bt,

242: --
243: CURSOR cur_check_pay_pay_value IS
244: SELECT feed.balance_feed_id
245: FROM pay_balance_feeds_f feed,
246: pay_balance_types bt,
247: pay_balance_classifications bc,
248: pay_element_types_f et,
249: pay_input_values_f iv
250: WHERE iv.input_value_id = p_input_value_id

Line 270: SELECT /+ INDEX (BT PAY_BALANCE_TYPES_PK) /

266: AND feed.effective_start_date <= iv.effective_end_date
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,

Line 283: FROM pay_balance_types bt,

279: iv.legislation_subgroup a_legislation_subgroup,
280: iv.last_updated_by a_last_updated_by,
281: iv.last_update_login a_last_update_login,
282: iv.created_by a_created_by
283: FROM pay_balance_types bt,
284: pay_balance_classifications bc,
285: pay_element_types_f et,
286: pay_input_values_f iv
287: WHERE iv.input_value_id = p_input_value_id

Line 306: pay_balance_types bt,

302: --
303: CURSOR cur_check_per_pay_value_prim IS
304: SELECT feed.balance_feed_id
305: FROM pay_balance_feeds_f feed,
306: pay_balance_types bt,
307: pay_balance_classifications bc,
308: pay_element_types_f et,
309: pay_input_values_f iv
310: WHERE iv.input_value_id = p_input_value_id

Line 330: SELECT /+ INDEX (BT PAY_BALANCE_TYPES_PK) /

326: AND feed.effective_start_date <= iv.effective_end_date
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,

Line 343: FROM pay_balance_types bt,

339: iv.legislation_subgroup a_legislation_subgroup,
340: iv.last_updated_by a_last_updated_by,
341: iv.last_update_login a_last_update_login,
342: iv.created_by a_created_by
343: FROM pay_balance_types bt,
344: pay_balance_classifications bc,
345: pay_element_types_f et,
346: pay_sub_classification_rules_f scr,
347: pay_input_values_f iv

Line 370: pay_balance_types bt,

366: --
367: CURSOR cur_check_per_pay_value_sub IS
368: SELECT feed.balance_feed_id
369: FROM pay_balance_feeds_f feed,
370: pay_balance_types bt,
371: pay_balance_classifications bc,
372: pay_element_types_f et,
373: pay_sub_classification_rules_f scr,
374: pay_input_values_f iv

Line 401: FROM pay_balance_types bt,

397: CURSOR cur_lock_manual_feed IS
398: SELECT iv.input_value_id,
399: et.element_type_id,
400: bt.balance_type_id
401: FROM pay_balance_types bt,
402: pay_element_types_f et,
403: pay_input_values_f iv
404: WHERE iv.input_value_id = p_input_value_id
405: AND et.element_type_id = iv.element_type_id

Line 417: pay_balance_types bt,

413: --
414: CURSOR cur_check_manual_feed IS
415: SELECT feed.balance_feed_id
416: FROM pay_balance_feeds_f feed,
417: pay_balance_types bt,
418: pay_element_types_f et,
419: pay_input_values_f iv
420: WHERE iv.input_value_id = p_input_value_id
421: AND et.element_type_id = iv.element_type_id

Line 440: FROM pay_balance_types bt,

436: et.element_type_id,
437: scr.sub_classification_rule_id,
438: bc.balance_classification_id,
439: bt.balance_type_id
440: FROM pay_balance_types bt,
441: pay_balance_classifications bc,
442: pay_element_types_f et,
443: pay_input_values_f_tl iv_tl,
444: pay_input_values_f iv,

Line 472: pay_balance_types bt,

468: --
469: CURSOR cur_check_sub_class_rule IS
470: SELECT feed.balance_feed_id
471: FROM pay_balance_feeds feed,
472: pay_balance_types bt,
473: pay_balance_classifications bc,
474: pay_element_types_f et,
475: pay_input_values_f_tl iv_tl,
476: pay_input_values_f iv,

Line 541: FROM pay_balance_types bt,

537: bc.scale a_scale,
538: bc.last_updated_by a_last_updated_by,
539: bc.last_update_login a_last_update_login,
540: bc.created_by a_created_by
541: FROM pay_balance_types bt,
542: pay_balance_classifications bc,
543: pay_sub_classification_rules_f scr
544: WHERE scr.sub_classification_rule_id
545: = p_sub_classification_rule_id

Line 561: FROM pay_balance_types bt,

557: CURSOR cur_lock_primary_bal_class IS
558: SELECT iv.input_value_id,
559: et.element_type_id,
560: bt.balance_type_id
561: FROM pay_balance_types bt,
562: pay_input_values_f_tl iv_tl,
563: pay_input_values_f iv,
564: pay_element_types_f et
565: WHERE iv_tl.input_value_id = iv.input_value_id

Line 586: pay_balance_types bt,

582: --
583: CURSOR cur_check_primary_bal_class IS
584: SELECT feed.balance_feed_id
585: FROM pay_balance_feeds_f feed,
586: pay_balance_types bt,
587: pay_input_values_f_tl iv_tl,
588: pay_input_values_f iv,
589: pay_element_types_f et
590: WHERE iv_tl.input_value_id = iv.input_value_id

Line 630: FROM pay_balance_types bt,

626: et.output_currency_code a_output_currency_code,
627: iv.business_group_id a_business_group_id,
628: iv.legislation_code a_legislation_code,
629: iv.legislation_subgroup a_legislation_subgroup
630: FROM pay_balance_types bt,
631: pay_input_values_f_tl iv_tl,
632: pay_input_values_f iv,
633: pay_element_types_f et
634: WHERE iv_tl.input_value_id = iv.input_value_id

Line 658: FROM pay_balance_types bt,

654: SELECT iv.input_value_id,
655: et.element_type_id,
656: scr.sub_classification_rule_id,
657: bt.balance_type_id
658: FROM pay_balance_types bt,
659: pay_element_types_f et,
660: pay_input_values_f_tl iv_tl,
661: pay_input_values_f iv,
662: pay_sub_classification_rules_f scr

Line 685: pay_balance_types bt,

681: --
682: CURSOR cur_check_sub_bal_class IS
683: SELECT feed.balance_feed_id
684: FROM pay_balance_feeds_f feed,
685: pay_balance_types bt,
686: pay_element_types_f et,
687: pay_input_values_f_tl iv_tl,
688: pay_input_values_f iv,
689: pay_sub_classification_rules_f scr

Line 723: FROM pay_balance_types bt,

719: et.output_currency_code a_output_currency_code,
720: iv.business_group_id a_business_group_id,
721: iv.legislation_code a_legislation_code,
722: iv.legislation_subgroup a_legislation_subgroup
723: FROM pay_balance_types bt,
724: pay_element_types_f et,
725: pay_input_values_f_tl iv_tl,
726: pay_input_values_f iv,
727: pay_sub_classification_rules_f scr

Line 1065: pay_balance_types bt

1061: iv.created_by,
1062: trunc(sysdate)
1063: FROM pay_input_values_f iv,
1064: pay_element_types_f et,
1065: pay_balance_types bt
1066: WHERE iv.input_value_id = p_input_value_id
1067: AND et.element_type_id = iv.element_type_id
1068: AND p_session_date between et.effective_start_date
1069: and et.effective_end_date

Line 1443: pay_balance_types bt

1439: bt.created_by,
1440: trunc(sysdate)
1441: FROM pay_input_values_f iv,
1442: pay_element_types_f et,
1443: pay_balance_types bt
1444: WHERE iv.input_value_id = p_input_value_id
1445: AND et.element_type_id = iv.element_type_id
1446: AND p_session_date between et.effective_start_date
1447: and et.effective_end_date

Line 1612: from pay_balance_types_tl b_tl,

1608: begin
1609: --
1610: select b_tl.balance_name
1611: into l_balance_name
1612: from pay_balance_types_tl b_tl,
1613: pay_balance_types b
1614: where b_tl.balance_type_id = b.balance_type_id
1615: and userenv('LANG') = b_tl.language
1616: and b.balance_type_id = p_balance_type_id

Line 1613: pay_balance_types b

1609: --
1610: select b_tl.balance_name
1611: into l_balance_name
1612: from pay_balance_types_tl b_tl,
1613: pay_balance_types b
1614: where b_tl.balance_type_id = b.balance_type_id
1615: and userenv('LANG') = b_tl.language
1616: and b.balance_type_id = p_balance_type_id
1617: and exists

Line 2228: This function looks in the table pay_balance_types_tl for balance type id passed to

2224: /*
2225: NAME
2226: decode_balance
2227: DESCRIPTION
2228: This function looks in the table pay_balance_types_tl for balance type id passed to
2229: the function. This function is called for the creation of the view
2230: pay_us_earnings_amounts_v which is in the payusblv.odf.
2231: */
2232:

Line 2237: from pay_balance_types_tl pbt

2233: function DECODE_balance ( p_balance_type_id number) return varchar2 is
2234: --
2235: cursor csr_balance is
2236: select balance_name
2237: from pay_balance_types_tl pbt
2238: where balance_type_id = p_balance_type_id
2239: and language = USERENV('LANG') ;
2240: --
2241: v_balance_name varchar2(80) := null;