APPS.GHR_FORMULA_FUNCTIONS dependencies on PER_PERIODS_OF_SERVICE

Line 1743: from per_all_people_f per, per_periods_of_service pps

1739:
1740: -- get hire date
1741: Cursor c_get_hire_date is
1742: select decode(PER.CURRENT_EMPLOYEE_FLAG,'Y',PPS.DATE_START,null) hire_date
1743: from per_all_people_f per, per_periods_of_service pps
1744: where per.person_id = v_person_id
1745: and per.person_id = pps.person_id
1746: and PER.EMPLOYEE_NUMBER IS NOT NULL
1747: and PPS.DATE_START = (SELECT MAX(PPS1.DATE_START)

Line 1748: FROM PER_PERIODS_OF_SERVICE PPS1

1744: where per.person_id = v_person_id
1745: and per.person_id = pps.person_id
1746: and PER.EMPLOYEE_NUMBER IS NOT NULL
1747: and PPS.DATE_START = (SELECT MAX(PPS1.DATE_START)
1748: FROM PER_PERIODS_OF_SERVICE PPS1
1749: WHERE PPS1.PERSON_ID = PER.PERSON_ID
1750: AND PPS1.DATE_START <= PER.EFFECTIVE_END_DATE) ;
1751:
1752: --check if this person exists in database

Line 1763: FROM PER_PERIODS_OF_SERVICE PPS1

1759: /*
1760:
1761: AND ((PER.EMPLOYEE_NUMBER IS NULL) OR
1762: (PER.EMPLOYEE_NUMBER IS NOT NULL AND PPS.DATE_START = (SELECT MAX(PPS1.DATE_START)
1763: FROM PER_PERIODS_OF_SERVICE PPS1
1764: WHERE PPS1.PERSON_ID = PER.PERSON_ID
1765: AND PPS1.DATE_START <= PER.EFFECTIVE_END_DATE))) AND ((PER.NPW_NUMBER IS NULL) OR
1766: (PER.NPW_NUMBER IS NOT NULL AND PPP.DATE_START =
1767: (SELECT MAX(PPP1.DATE_START) FROM PER_PERIODS_OF_PLACEMENT PPP1