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 FF_DATABASE_ITEMS

Line 542: ff_database_items dbi

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
545: AND arc.context1 = p_asgn_action_id
546: and (( irp5.balance_sequence = 1 and

Line 600: ff_database_items dbi,

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
603: WHERE irp5.code IN (3608, 3614, 3707, 3718, 3901, 3902, 3903, 3904, 3905, 3906, 3907, 3909, 3915, 3920)
604: AND irp5.balance_sequence = 3

Line 623: ff_database_items dbi,

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
626: where arc.context1 in (select ch.assignment_action_id
627: from pay_assignment_actions main

Line 660: ff_database_items dbi,

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
663: WHERE irp5.code IN (4001, 4002, 4003, 4004, 4006, 4007)
664: AND irp5.balance_sequence = 1

Line 683: ff_database_items dbi

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
686: AND irp5.user_name = dbi.user_name
687: AND dbi.user_entity_id = arc.user_entity_id

Line 698: ff_database_items dbi

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
701: irp5.balance_sequence = 1
702: )

Line 769: ff_database_items dbi,

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
772: WHERE dbi.user_name in
773: (

Line 926: ff_database_items dbi,

922: CURSOR chk_rtrmnt_fnd_cur ( p_asgn_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
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

Line 950: ff_database_items dbi,

946: CURSOR fetch_lmpsm_code_bal_cur ( p_asgn_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
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

Line 1006: ff_database_items dbi

1002: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Rule 1) If Employee has paid tax during current tax year, he should have SITE/PAYE split');
1003: select pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))
1004: into l_tax_ytd
1005: from ff_archive_items arc,
1006: ff_database_items dbi
1007: where dbi.user_name = 'A_TAX_ASG_TAX_YTD'
1008: and arc.user_entity_id = dbi.user_entity_id
1009: and arc.context1 = asgn.assignment_action_id;
1010:

Line 1015: ff_database_items dbi

1011: IF l_tax_ytd > 0 THEN
1012: select pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))
1013: into l_site
1014: from ff_archive_items arc,
1015: ff_database_items dbi
1016: where dbi.user_name = 'A_SITE_ASG_TAX_YTD'
1017: and arc.user_entity_id = dbi.user_entity_id
1018: and arc.context1 = asgn.assignment_action_id;
1019:

Line 1023: ff_database_items dbi

1019:
1020: select pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))
1021: into l_paye
1022: from ff_archive_items arc,
1023: ff_database_items dbi
1024: where dbi.user_name = 'A_PAYE_ASG_TAX_YTD'
1025: and arc.user_entity_id = dbi.user_entity_id
1026: and arc.context1 = asgn.assignment_action_id;
1027: