[Home] [Help]
27: --
28: Description : This package holds procedures and functions related to the
29: following tables :
30: --
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
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
228: AND et.element_type_id = iv.element_type_id
229: AND et.effective_start_date <= p_session_date
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
251: AND et.element_type_id = iv.element_type_id
252: AND et.effective_start_date <= p_session_date
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
288: AND et.element_type_id = iv.element_type_id
289: AND et.effective_start_date <= p_session_date
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
311: AND et.element_type_id = iv.element_type_id
312: AND et.effective_start_date <= p_session_date
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
348: WHERE iv.input_value_id = p_input_value_id
349: AND scr.element_type_id = iv.element_type_id
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
375: WHERE iv.input_value_id = p_input_value_id
376: AND scr.element_type_id = iv.element_type_id
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
406: AND et.effective_start_date <= p_session_date
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
422: AND et.effective_start_date <= p_session_date
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,
445: pay_sub_classification_rules_f scr
446: WHERE iv_tl.input_value_id = iv.input_value_id
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,
477: pay_sub_classification_rules_f scr
478: WHERE iv_tl.input_value_id = iv.input_value_id
509: et.output_currency_code a_output_currency_code,
510: iv.business_group_id a_business_group_id,
511: iv.legislation_code a_legislation_code,
512: iv.legislation_subgroup a_legislation_subgroup
513: FROM pay_element_types_f et,
514: pay_input_values_f_tl iv_tl,
515: pay_input_values_f iv,
516: pay_sub_classification_rules_f scr
517: WHERE iv_tl.input_value_id = iv.input_value_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
566: and userenv('LANG') = iv_tl.language
567: and et.classification_id = p_primary_classification_id
568: AND et.effective_start_date <= p_session_date
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
591: and userenv('LANG') = iv_tl.language
592: and et.classification_id = p_primary_classification_id
593: AND et.effective_start_date <= p_session_date
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
635: and userenv('LANG') = iv_tl.language
636: and et.classification_id = p_primary_classification_id
637: AND et.effective_start_date <= p_session_date
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
663: WHERE iv_tl.input_value_id = iv.input_value_id
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
690: WHERE iv_tl.input_value_id = iv.input_value_id
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
728: WHERE iv_tl.input_value_id = iv.input_value_id
1060: iv.last_update_login,
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
1438: bt.last_update_login,
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
1537: WHERE balance_type_id = p_balance_type_id
1538: AND input_value_id in
1539: (SELECT iv.input_value_id
1540: FROM pay_input_values_f iv,
1541: pay_element_types_f et
1542: WHERE iv.element_type_id = et.element_type_id
1543: and et.classification_id
1544: = p_primary_classification_id
1545: AND iv.name = 'Pay Value');
1928: WHERE balance_type_id = p_balance_type_id
1929: AND input_value_id IN
1930: (SELECT iv.input_value_id
1931: FROM pay_input_values_f iv,
1932: pay_element_types_f et
1933: WHERE iv.element_type_id = et.element_type_id
1934: and et.classification_id
1935: = p_primary_classification_id
1936: AND iv.name = 'Pay Value'));
1940: WHERE balance_type_id = p_balance_type_id
1941: AND input_value_id in
1942: (SELECT iv.input_value_id
1943: FROM pay_input_values_f iv,
1944: pay_element_types_f et
1945: WHERE iv.element_type_id = et.element_type_id
1946: and et.classification_id
1947: = p_primary_classification_id
1948: AND iv.name = 'Pay Value');
2147: if l_greatest_date is null then
2148: --
2149: select max(et.effective_end_date)
2150: into l_greatest_date
2151: from pay_element_types_f et
2152: where p_element_type_id = et.element_type_id;
2153: --
2154: end if;
2155: --