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.HR_NO_UTILITY dependencies on PAY_ELEMENT_ENTRIES_F

Line 634: ( p_EE_ID pay_element_entries_f.ELEMENT_ENTRY_ID%TYPE,

630:
631: -- function for Norway BIK to get element entry effective start date
632:
633: FUNCTION Get_EE_EFF_START_DATE
634: ( p_EE_ID pay_element_entries_f.ELEMENT_ENTRY_ID%TYPE,
635: p_date_earned DATE )
636: RETURN DATE
637: IS
638: l_Date DATE;

Line 643: from pay_element_entries_f

639: BEGIN
640: BEGIN
641: select EFFECTIVE_START_DATE
642: INTO l_Date
643: from pay_element_entries_f
644: where element_entry_id=p_EE_ID
645: and p_date_earned between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
646: EXCEPTION
647: WHEN NO_DATA_FOUND

Line 661: ( p_EE_ID pay_element_entries_f.ELEMENT_ENTRY_ID%TYPE,

657:
658: -- function for Norway BIK to get element entry effective end date
659:
660: FUNCTION Get_EE_EFF_END_DATE
661: ( p_EE_ID pay_element_entries_f.ELEMENT_ENTRY_ID%TYPE,
662: p_date_earned DATE )
663: RETURN DATE
664: IS
665: l_Date DATE;

Line 670: from pay_element_entries_f

666: BEGIN
667: BEGIN
668: select EFFECTIVE_END_DATE
669: INTO l_Date
670: from pay_element_entries_f
671: where element_entry_id=p_EE_ID
672: and p_date_earned between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
673:
674: EXCEPTION