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_ARCHIVE_ITEMS

Line 385: ff_archive_items arc,

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

Line 438: ff_archive_items arc,

434: CURSOR fetch_lmpsm_bal_cur ( p_asgn_action_id pay_assignment_actions.assignment_action_id%TYPE) is
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)

Line 461: ff_archive_items arc,

457: select sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(arc.value)))) value
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

Line 499: ff_archive_items arc,

495: select irp5.code ,
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)

Line 523: ff_archive_items arc,

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

Line 587: ff_archive_items arc,

583: irp5.full_balance_name bal_name,
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

Line 698: l_tax_ytd ff_archive_items.value%TYPE ; -- to save Tax paid by employee during tax year

694: retiremnt_fund_lmpsum med_code_tab;
695:
696: l_empno per_all_people_f.employee_number%type;
697: l_assgno per_all_assignments_f.assignment_number%type;
698: l_tax_ytd ff_archive_items.value%TYPE ; -- to save Tax paid by employee during tax year
699: l_site ff_archive_items.value%TYPE ;
700: l_paye ff_archive_items.value%TYPE ;
701: l_msgtext varchar2(2000);
702: l_missing_clrno_flag VARCHAR2(1) ;

Line 699: l_site ff_archive_items.value%TYPE ;

695:
696: l_empno per_all_people_f.employee_number%type;
697: l_assgno per_all_assignments_f.assignment_number%type;
698: l_tax_ytd ff_archive_items.value%TYPE ; -- to save Tax paid by employee during tax year
699: l_site ff_archive_items.value%TYPE ;
700: l_paye ff_archive_items.value%TYPE ;
701: l_msgtext varchar2(2000);
702: l_missing_clrno_flag VARCHAR2(1) ;
703: l_count NUMBER :=0;

Line 700: l_paye ff_archive_items.value%TYPE ;

696: l_empno per_all_people_f.employee_number%type;
697: l_assgno per_all_assignments_f.assignment_number%type;
698: l_tax_ytd ff_archive_items.value%TYPE ; -- to save Tax paid by employee during tax year
699: l_site ff_archive_items.value%TYPE ;
700: l_paye ff_archive_items.value%TYPE ;
701: l_msgtext varchar2(2000);
702: l_missing_clrno_flag VARCHAR2(1) ;
703: l_count NUMBER :=0;
704: l_count1 NUMBER :=0;

Line 735: FROM ff_archive_items arc,

731:
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

Line 772: from ff_archive_items arc,

768: -- they must have a value in the SITE and/or PAYE balance (SITE_ASG_TAX_YTD or PAYE_ASG_TAX_YTD)
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;

Line 781: from ff_archive_items arc,

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;

Line 789: from ff_archive_items arc,

785: and arc.context1 = asgn.assignment_action_id;
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;