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_ASSIGNMENT_ACTIONS

Line 381: CURSOR negative_amt_check_cur(p_asgn_action_id pay_assignment_actions.assignment_action_id%TYPE) IS

377: g_default_clrno CONSTANT VARCHAR2(11) := '99999999999' ;
378: g_default_dirno CONSTANT VARCHAR2(7) := 'Default' ;
379: g_application_id CONSTANT NUMBER := 801 ;
380:
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,

Line 434: CURSOR fetch_lmpsm_bal_cur ( p_asgn_action_id pay_assignment_actions.assignment_action_id%TYPE) is

430: group by irp5.code
431: HAVING sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))))) < 0 ;
432:
433: /* Cursor to fetch all LumpSum Balance Sars Codes ( For Main Certificate) which have neagtive amounts*/
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,

Line 456: CURSOR get_lmpsm_crt_bal (p_asg_act_id pay_assignment_actions.assignment_action_id%TYPE) is

452: HAVING sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0)))))<0 ;
453:
454: /* Cursor to fetch The -ve Lump Sum balances with Directive Number other than Default
455: That is checking the Lump Sum Certificate balances */
456: CURSOR get_lmpsm_crt_bal (p_asg_act_id pay_assignment_actions.assignment_action_id%TYPE) is
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,

Line 466: from pay_assignment_actions main

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
467: , pay_assignment_actions ch
468: where main.assignment_action_id = p_asg_act_id
469: and ch.payroll_action_id = main.payroll_action_id
470: and ch.assignment_action_id < main.assignment_action_id

Line 467: , pay_assignment_actions ch

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
467: , pay_assignment_actions ch
468: where main.assignment_action_id = p_asg_act_id
469: and ch.payroll_action_id = main.payroll_action_id
470: and ch.assignment_action_id < main.assignment_action_id
471: AND ch.assignment_id = main.assignment_id)

Line 494: CURSOR fetch_deduction_bal_cur ( p_asgn_action_id pay_assignment_actions.assignment_action_id%type) IS

490: HAVING sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(arc.value)))) < 0;
491:
492:
493: /*Cursor to fetch all Deduction Balances which have either negative amounts or missing clearance numbers*/
494: CURSOR fetch_deduction_bal_cur ( p_asgn_action_id pay_assignment_actions.assignment_action_id%type) IS
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,

Line 519: CURSOR fetch_med_code_bal_cur ( p_asgn_action_id pay_assignment_actions.assignment_action_id%TYPE) IS

515: and sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))))) <> 0);
516: --added above condition for Bug 7214056
517:
518: /*Cursor to fetch Medical Aid Code Values for Cross Validation*/
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,

Line 536: FROM pay_assignment_actions

532: /* Cursor to fetch all assignment_id and max(assignment_action_id) for given payroll_action_id */
533: CURSOR asgn_for_payroll_action_cur IS
534: SELECT assignment_id,
535: max(assignment_action_id) assignment_action_id -- max assignment_action_id relates to Main Certificate
536: FROM pay_assignment_actions
537: WHERE payroll_action_id = p_payroll_action_id
538: GROUP BY assignment_id ;
539:
540: /*Cursor to fetch assignment_action_id corresponding to payroll run for given assignment_id and that tax year*/

Line 541: CURSOR payroll_asgn_ac_id_cur(p_asgn_id pay_assignment_actions.assignment_id%type,

537: WHERE payroll_action_id = p_payroll_action_id
538: GROUP BY assignment_id ;
539:
540: /*Cursor to fetch assignment_action_id corresponding to payroll run for given assignment_id and that tax year*/
541: CURSOR payroll_asgn_ac_id_cur(p_asgn_id pay_assignment_actions.assignment_id%type,
542: p_start_date DATE,
543: p_end_date DATE) IS
544: select paa.assignment_action_id
545: from pay_action_contexts pac,

Line 546: pay_assignment_actions paa,

542: p_start_date DATE,
543: p_end_date DATE) IS
544: select paa.assignment_action_id
545: from pay_action_contexts pac,
546: pay_assignment_actions paa,
547: pay_payroll_actions ppa,
548: ff_contexts ffc
549: where paa.assignment_id = p_asgn_id
550: and paa.payroll_action_id = ppa.payroll_action_id

Line 560: CURSOR elem_names_cur (p_asgn_ac_id pay_assignment_actions.assignment_action_id%type)IS

556: and ppa.effective_date >= p_start_date
557: and ppa.effective_date <= p_end_date;
558:
559: /*Cursor the fetch all element names which have missing clearance numbers for given assignment_id*/
560: CURSOR elem_names_cur (p_asgn_ac_id pay_assignment_actions.assignment_action_id%type)IS
561: Select element_name
562: FROM pay_assignment_actions paa,
563: pay_payroll_actions ppa,
564: pay_element_types_f pet,

Line 562: FROM pay_assignment_actions paa,

558:
559: /*Cursor the fetch all element names which have missing clearance numbers for given assignment_id*/
560: CURSOR elem_names_cur (p_asgn_ac_id pay_assignment_actions.assignment_action_id%type)IS
561: Select element_name
562: FROM pay_assignment_actions paa,
563: pay_payroll_actions ppa,
564: pay_element_types_f pet,
565: pay_input_values_f piv,
566: pay_run_results prr,

Line 581: CURSOR fetch_pkg_balances( p_asgn_action_id pay_assignment_actions.assignment_action_id%type) IS

577: and ppa.effective_date between pet.effective_start_date and pet.effective_end_date
578: and ppa.effective_date between piv.effective_start_date and piv.effective_end_date ;
579:
580: /*To fetch PKG balance feed for employee not on pension basis */
581: CURSOR fetch_pkg_balances( p_asgn_action_id pay_assignment_actions.assignment_action_id%type) IS
582: select irp5.code,
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

Line 590: pay_assignment_actions paa

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: (
593: 'A_ANNUAL_ASSET_PURCHASED_AT_REDUCED_VALUE_PKG_ASG_TAX_YTD',
594: 'A_ASSET_PURCHASED_AT_REDUCED_VALUE_PKG_ASG_TAX_YTD',

Line 655: CURSOR fetch_pkg_ele( p_asgn_action_id pay_assignment_actions.assignment_action_id%type, p_bal_typ_id pay_balance_types.balance_type_id%type) IS

651: AND paei.information_type = 'ZA_SPECIFIC_INFO'
652: AND pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0)) <> '0';
653:
654: /*Fetch elements feeding to PKG classification */
655: CURSOR fetch_pkg_ele( p_asgn_action_id pay_assignment_actions.assignment_action_id%type, p_bal_typ_id pay_balance_types.balance_type_id%type) IS
656: SELECT ELEM.element_name element_name,
657: sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(TARGET.RESULT_VALUE,0)))))
658: from pay_balance_feeds_f FEED
659: , pay_run_result_values TARGET

Line 664: , pay_assignment_actions ASSACT

660: , pay_run_results RR
661: , per_time_periods PPTP
662: , per_time_periods BPTP
663: , pay_payroll_actions PACT
664: , pay_assignment_actions ASSACT
665: , pay_payroll_actions BACT
666: , pay_assignment_actions BAL_ASSACT
667: , pay_element_types_f ELEM
668: where BAL_ASSACT.assignment_action_id = p_asgn_action_id

Line 666: , pay_assignment_actions BAL_ASSACT

662: , per_time_periods BPTP
663: , pay_payroll_actions PACT
664: , pay_assignment_actions ASSACT
665: , pay_payroll_actions BACT
666: , pay_assignment_actions BAL_ASSACT
667: , pay_element_types_f ELEM
668: where BAL_ASSACT.assignment_action_id = p_asgn_action_id
669: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
670: and FEED.input_value_id = TARGET.input_value_id

Line 708: CURSOR emp_number_cur ( asgn_ac_id pay_assignment_actions.assignment_action_id%TYPE) IS

704: l_count1 NUMBER :=0;
705:
706:
707: --Changes done for Bug No 6749775
708: CURSOR emp_number_cur ( asgn_ac_id pay_assignment_actions.assignment_action_id%TYPE) IS
709: SELECT per.employee_number empno, asgn2.assignment_number assgno
710: FROM pay_assignment_actions paa,
711: per_all_assignments_f asgn2,
712: per_all_people_f per,

Line 710: FROM pay_assignment_actions paa,

706:
707: --Changes done for Bug No 6749775
708: CURSOR emp_number_cur ( asgn_ac_id pay_assignment_actions.assignment_action_id%TYPE) IS
709: SELECT per.employee_number empno, asgn2.assignment_number assgno
710: FROM pay_assignment_actions paa,
711: per_all_assignments_f asgn2,
712: per_all_people_f per,
713: pay_payroll_actions ppa
714: WHERE paa.assignment_action_id = asgn_ac_id

Line 733: CURSOR chk_rtrmnt_fnd_cur ( p_asgn_action_id pay_assignment_actions.assignment_action_id%TYPE) IS

729: );
730: --End changes for Bug No 6749775
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