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.PAY_ZA_EOY_VAL dependencies on PAY_ZA_IRP5_BAL_CODES

Line 540: FROM pay_za_irp5_bal_codes irp5,

536:
537: CURSOR negative_amt_check_cur(p_asgn_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
538: select irp5.code,
539: sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))))) value
540: FROM pay_za_irp5_bal_codes irp5,
541: ff_archive_items arc,
542: ff_database_items dbi
543: WHERE dbi.user_entity_id = arc.user_entity_id
544: and irp5.user_name = dbi.user_name

Line 598: FROM pay_za_irp5_bal_codes irp5,

594: /* Cursor to fetch all LumpSum Balance Sars Codes ( For Main Certificate) which have neagtive amounts*/
595: CURSOR fetch_lmpsm_bal_cur ( p_asgn_action_id pay_assignment_actions.assignment_action_id%TYPE) is
596: select irp5.code,
597: sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))))) value
598: FROM pay_za_irp5_bal_codes irp5,
599: ff_archive_items arc,
600: ff_database_items dbi,
601: ff_archive_item_contexts faic2,
602: ff_contexts ffc2

Line 621: from pay_za_irp5_bal_codes irp5,

617: CURSOR get_lmpsm_crt_bal (p_asg_act_id pay_assignment_actions.assignment_action_id%TYPE) is
618: select sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(arc.value)))) value
619: , faic2.CONTEXT Tax_Directive_Number
620: , irp5.code code
621: from pay_za_irp5_bal_codes irp5,
622: ff_archive_items arc,
623: ff_database_items dbi,
624: ff_archive_item_contexts faic2,
625: ff_contexts ffc2

Line 658: FROM pay_za_irp5_bal_codes irp5,

654: CURSOR fetch_deduction_bal_cur ( p_asgn_action_id pay_assignment_actions.assignment_action_id%type) IS
655: select irp5.code ,
656: faic2.CONTEXT clearance_num,
657: sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))))) value
658: FROM pay_za_irp5_bal_codes irp5,
659: ff_archive_items arc,
660: ff_database_items dbi,
661: ff_archive_item_contexts faic2,
662: ff_contexts ffc2

Line 681: FROM pay_za_irp5_bal_codes irp5,

677: UNION /*Added for Bug 8406456 to report negative amount in code 4030. This deduction doesnt have clearance number */
678: select irp5.code ,
679: '11111111111' clearance_num,
680: sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))))) value
681: FROM pay_za_irp5_bal_codes irp5,
682: ff_archive_items arc,
683: ff_database_items dbi
684: WHERE irp5.code IN (4030)
685: AND irp5.balance_sequence = 1

Line 696: FROM pay_za_irp5_bal_codes irp5,

692: /*Cursor to fetch Medical Aid Code Values/Lump Sums for Cross Validation*/
693: CURSOR fetch_med_code_bal_cur ( p_asgn_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
694: select irp5.code,
695: sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))))) value
696: FROM pay_za_irp5_bal_codes irp5,
697: ff_archive_items arc,
698: ff_database_items dbi
699: WHERE ((irp5.code IN (3810, 3813, 4005, 4024, 4025, 4474, 4485, 4486, 4493, 4030) --Added 4474 and 4493 for TYE09
700: AND

Line 767: FROM pay_za_irp5_bal_codes irp5,

763: select irp5.code,
764: irp5.full_balance_name bal_name,
765: irp5.balance_type_id bal_type_id,
766: trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0)))) value
767: FROM pay_za_irp5_bal_codes irp5,
768: ff_archive_items arc,
769: ff_database_items dbi,
770: per_assignment_extra_info paei,
771: pay_assignment_actions paa

Line 927: pay_za_irp5_bal_codes irp5,

923: SELECT irp5.code, sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))))) value,
924: faic2.CONTEXT Tax_Directive_Number
925: FROM ff_archive_items arc,
926: ff_database_items dbi,
927: pay_za_irp5_bal_codes irp5,
928: ff_archive_item_contexts faic2,
929: ff_contexts ffc2
930: WHERE arc.user_entity_id = dbi.user_entity_id
931: and irp5.user_name = dbi.user_name

Line 951: pay_za_irp5_bal_codes irp5,

947: SELECT irp5.code, sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))))) value,
948: faic2.CONTEXT Tax_Directive_Number
949: FROM ff_archive_items arc,
950: ff_database_items dbi,
951: pay_za_irp5_bal_codes irp5,
952: ff_archive_item_contexts faic2,
953: ff_contexts ffc2
954: WHERE arc.user_entity_id = dbi.user_entity_id
955: and irp5.user_name = dbi.user_name