APPS.HR_NO_UTILITY dependencies on PAY_ELEMENT_ENTRIES_F

Line 675: ( p_EE_ID pay_element_entries_f.ELEMENT_ENTRY_ID%TYPE,

671: END get_employment_information;
672:
673: --
674: FUNCTION Get_LOAN_START_DATE
675: ( p_EE_ID pay_element_entries_f.ELEMENT_ENTRY_ID%TYPE,
676: p_date_earned DATE )
677: RETURN DATE
678: IS
679: l_Date DATE;

Line 684: from pay_element_entries_f

680: BEGIN
681: BEGIN
682: select min(EFFECTIVE_START_DATE)
683: INTO l_Date
684: from pay_element_entries_f
685: where element_entry_id=p_EE_ID;
686:
687: EXCEPTION
688: WHEN NO_DATA_FOUND

Line 701: ( p_EE_ID pay_element_entries_f.ELEMENT_ENTRY_ID%TYPE,

697:
698: -- function for Norway BIK to get element entry effective start date
699:
700: FUNCTION Get_EE_EFF_START_DATE
701: ( p_EE_ID pay_element_entries_f.ELEMENT_ENTRY_ID%TYPE,
702: p_date_earned DATE )
703: RETURN DATE
704: IS
705: l_Date DATE;

Line 710: from pay_element_entries_f

706: BEGIN
707: BEGIN
708: select EFFECTIVE_START_DATE
709: INTO l_Date
710: from pay_element_entries_f
711: where element_entry_id=p_EE_ID
712: and p_date_earned between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
713: EXCEPTION
714: WHEN NO_DATA_FOUND

Line 728: ( p_EE_ID pay_element_entries_f.ELEMENT_ENTRY_ID%TYPE,

724:
725: -- function for Norway BIK to get element entry effective end date
726:
727: FUNCTION Get_EE_EFF_END_DATE
728: ( p_EE_ID pay_element_entries_f.ELEMENT_ENTRY_ID%TYPE,
729: p_date_earned DATE )
730: RETURN DATE
731: IS
732: l_Date DATE;

Line 737: from pay_element_entries_f

733: BEGIN
734: BEGIN
735: select EFFECTIVE_END_DATE
736: INTO l_Date
737: from pay_element_entries_f
738: where element_entry_id=p_EE_ID
739: and p_date_earned between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;
740:
741: EXCEPTION