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.PER_ZA_UTILITY_PKG dependencies on PAY_ELEMENT_LINKS_F

Line 635: p_element_link_id IN pay_element_links_f.element_link_id%TYPE

631: -------------------------------------------------------------------------------
632: -- elm_link_start_date
633: -------------------------------------------------------------------------------
634: FUNCTION elm_link_start_date (
635: p_element_link_id IN pay_element_links_f.element_link_id%TYPE
636: )
637: RETURN pay_element_links_f.effective_start_date%TYPE AS
638: ---------
639: -- Cursor

Line 637: RETURN pay_element_links_f.effective_start_date%TYPE AS

633: -------------------------------------------------------------------------------
634: FUNCTION elm_link_start_date (
635: p_element_link_id IN pay_element_links_f.element_link_id%TYPE
636: )
637: RETURN pay_element_links_f.effective_start_date%TYPE AS
638: ---------
639: -- Cursor
640: ---------
641: CURSOR c_start_date(

Line 642: p_elm_lnk_id IN pay_element_links_f.element_link_id%TYPE

638: ---------
639: -- Cursor
640: ---------
641: CURSOR c_start_date(
642: p_elm_lnk_id IN pay_element_links_f.element_link_id%TYPE
643: )
644: IS
645: select min(pel.effective_start_date)
646: from pay_element_links_f pel

Line 646: from pay_element_links_f pel

642: p_elm_lnk_id IN pay_element_links_f.element_link_id%TYPE
643: )
644: IS
645: select min(pel.effective_start_date)
646: from pay_element_links_f pel
647: where pel.element_link_id = p_elm_lnk_id;
648:
649: ------------
650: -- Variables

Line 652: l_min_eff_start_date pay_element_links_f.effective_start_date%TYPE;

648:
649: ------------
650: -- Variables
651: ------------
652: l_min_eff_start_date pay_element_links_f.effective_start_date%TYPE;
653:
654: -------------------------------------------------------------------------------
655: BEGIN -- MAIN --
656: -------------------------------------------------------------------------------

Line 684: p_element_link_id IN pay_element_links_f.element_link_id%TYPE

680: -------------------------------------------------------------------------------
681: -- elm_link_end_date
682: -------------------------------------------------------------------------------
683: FUNCTION elm_link_end_date (
684: p_element_link_id IN pay_element_links_f.element_link_id%TYPE
685: )
686: RETURN pay_element_links_f.effective_end_date%TYPE AS
687: ---------
688: -- Cursor

Line 686: RETURN pay_element_links_f.effective_end_date%TYPE AS

682: -------------------------------------------------------------------------------
683: FUNCTION elm_link_end_date (
684: p_element_link_id IN pay_element_links_f.element_link_id%TYPE
685: )
686: RETURN pay_element_links_f.effective_end_date%TYPE AS
687: ---------
688: -- Cursor
689: ---------
690: CURSOR c_end_date(

Line 691: p_elm_lnk_id IN pay_element_links_f.element_link_id%TYPE

687: ---------
688: -- Cursor
689: ---------
690: CURSOR c_end_date(
691: p_elm_lnk_id IN pay_element_links_f.element_link_id%TYPE
692: )
693: IS
694: select max(pel.effective_end_date)
695: from pay_element_links_f pel

Line 695: from pay_element_links_f pel

691: p_elm_lnk_id IN pay_element_links_f.element_link_id%TYPE
692: )
693: IS
694: select max(pel.effective_end_date)
695: from pay_element_links_f pel
696: where pel.element_link_id = p_elm_lnk_id;
697:
698: ------------
699: -- Variables

Line 701: l_max_eff_end_date pay_element_links_f.effective_end_date%TYPE;

697:
698: ------------
699: -- Variables
700: ------------
701: l_max_eff_end_date pay_element_links_f.effective_end_date%TYPE;
702:
703: -------------------------------------------------------------------------------
704: BEGIN -- MAIN --
705: -------------------------------------------------------------------------------

Line 749: pay_element_links_f pel

745: , piv.max_value
746: , piv.min_value
747: , piv.warning_or_error
748: from
749: pay_element_links_f pel
750: , pay_input_values_f piv
751: , pay_element_types_f pet
752: where
753: pet.element_type_id = pel.element_type_id

Line 763: from pay_element_links_f pel2

759: and pel.effective_end_date between pet.effective_start_date
760: and pet.effective_end_date
761: and pel.effective_end_date =
762: ( select max(pel2.effective_end_date)
763: from pay_element_links_f pel2
764: where pel2.element_link_id = pel.element_link_id
765: )
766: and not exists
767: ( select

Line 776: from pay_element_links_f pel2

772: pli.element_link_id = pel.element_link_id
773: and pli.input_value_id = piv.input_value_id
774: and pli.effective_start_date >=
775: ( select min(pel2.effective_start_date)
776: from pay_element_links_f pel2
777: where pel2.element_link_id = pli.element_link_id
778: )
779: and pli.effective_end_date <=
780: ( select max(pel2.effective_end_date)

Line 781: from pay_element_links_f pel2

777: where pel2.element_link_id = pli.element_link_id
778: )
779: and pli.effective_end_date <=
780: ( select max(pel2.effective_end_date)
781: from pay_element_links_f pel2
782: where pel2.element_link_id = pli.element_link_id
783: )
784: );
785:

Line 790: p_element_link_id IN pay_element_links_f.element_link_id%TYPE

786: ---------
787: -- Cursor
788: ---------
789: CURSOR c_element_entries(
790: p_element_link_id IN pay_element_links_f.element_link_id%TYPE
791: )
792: IS
793: select pee.effective_start_date effective_start_date
794: , pee.effective_end_date effective_end_date

Line 802: l_ipv_link_start_date pay_element_links_f.effective_start_date%TYPE;

798:
799: ------------
800: -- Variables
801: ------------
802: l_ipv_link_start_date pay_element_links_f.effective_start_date%TYPE;
803: l_ipv_link_end_date pay_element_links_f.effective_end_date%TYPE;
804:
805: -------------------------------------------------------------------------------
806: BEGIN -- MAIN --

Line 803: l_ipv_link_end_date pay_element_links_f.effective_end_date%TYPE;

799: ------------
800: -- Variables
801: ------------
802: l_ipv_link_start_date pay_element_links_f.effective_start_date%TYPE;
803: l_ipv_link_end_date pay_element_links_f.effective_end_date%TYPE;
804:
805: -------------------------------------------------------------------------------
806: BEGIN -- MAIN --
807: -------------------------------------------------------------------------------