[Home] [Help]
382: select irp5.code,
383: sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))))) value
384: FROM pay_za_irp5_bal_codes irp5,
385: ff_archive_items arc,
386: ff_database_items dbi
387: WHERE dbi.user_entity_id = arc.user_entity_id
388: and irp5.user_name = dbi.user_name
389: AND arc.context1 = p_asgn_action_id
390: and irp5.balance_sequence = 1
435: select irp5.code,
436: sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))))) value
437: FROM pay_za_irp5_bal_codes irp5,
438: ff_archive_items arc,
439: ff_database_items dbi,
440: ff_archive_item_contexts faic2,
441: ff_contexts ffc2
442: WHERE irp5.code IN (3608, 3614, 3707, 3718, 3901, 3902, 3903, 3904, 3905, 3906, 3907, 3908, 3909, 3915)
443: AND irp5.balance_sequence = 3
458: , faic2.CONTEXT Tax_Directive_Number
459: , irp5.code code
460: from pay_za_irp5_bal_codes irp5,
461: ff_archive_items arc,
462: ff_database_items dbi,
463: ff_archive_item_contexts faic2,
464: ff_contexts ffc2
465: where arc.context1 in (select ch.assignment_action_id
466: from pay_assignment_actions main
496: faic2.CONTEXT clearance_num,
497: sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))))) value
498: FROM pay_za_irp5_bal_codes irp5,
499: ff_archive_items arc,
500: ff_database_items dbi,
501: ff_archive_item_contexts faic2,
502: ff_contexts ffc2
503: WHERE irp5.code IN (4001, 4002, 4003, 4004, 4006, 4007)
504: AND irp5.balance_sequence = 1
520: select irp5.code,
521: sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))))) value
522: FROM pay_za_irp5_bal_codes irp5,
523: ff_archive_items arc,
524: ff_database_items dbi
525: WHERE irp5.code IN (3810, 3813, 4005, 4024, 4025, 4485, 4486)
526: AND irp5.balance_sequence = 1
527: AND irp5.user_name = dbi.user_name
528: AND dbi.user_entity_id = arc.user_entity_id
584: irp5.balance_type_id bal_type_id,
585: trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0)))) value
586: FROM pay_za_irp5_bal_codes irp5,
587: ff_archive_items arc,
588: ff_database_items dbi,
589: per_assignment_extra_info paei,
590: pay_assignment_actions paa
591: WHERE dbi.user_name in
592: (
732: /* Cursor to check sanity of 3915 and 4115 codes */
733: CURSOR chk_rtrmnt_fnd_cur ( p_asgn_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
734: SELECT irp5.code, sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))))) value
735: FROM ff_archive_items arc,
736: ff_database_items dbi,
737: pay_za_irp5_bal_codes irp5
738: WHERE arc.user_entity_id = dbi.user_entity_id
739: and irp5.user_name = dbi.user_name
740: and arc.context1 in (p_asgn_action_id)
769: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Rule 1) If Employee has paid tax during current tax year, he should have SITE/PAYE split');
770: select pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))
771: into l_tax_ytd
772: from ff_archive_items arc,
773: ff_database_items dbi
774: where dbi.user_name = 'A_TAX_ASG_TAX_YTD'
775: and arc.user_entity_id = dbi.user_entity_id
776: and arc.context1 = asgn.assignment_action_id;
777:
778: IF l_tax_ytd > 0 THEN
779: select pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))
780: into l_site
781: from ff_archive_items arc,
782: ff_database_items dbi
783: where dbi.user_name = 'A_SITE_ASG_TAX_YTD'
784: and arc.user_entity_id = dbi.user_entity_id
785: and arc.context1 = asgn.assignment_action_id;
786:
786:
787: select pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))
788: into l_paye
789: from ff_archive_items arc,
790: ff_database_items dbi
791: where dbi.user_name = 'A_PAYE_ASG_TAX_YTD'
792: and arc.user_entity_id = dbi.user_entity_id
793: and arc.context1 = asgn.assignment_action_id;
794: