APPS.GHR_FORMULA_FUNCTIONS dependencies on PER_PERIODS_OF_SERVICE

Line 1747: from per_all_people_f per, per_periods_of_service pps

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

Line 1752: FROM PER_PERIODS_OF_SERVICE PPS1

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

Line 1767: FROM PER_PERIODS_OF_SERVICE PPS1

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

Line 2288: from per_all_people_f per, per_periods_of_service pps

2284:
2285: -- get hire date
2286: Cursor c_get_hire_date is
2287: select decode(PER.CURRENT_EMPLOYEE_FLAG,'Y',PPS.DATE_START,null) hire_date
2288: from per_all_people_f per, per_periods_of_service pps
2289: where per.person_id = v_person_id
2290: and per.person_id = pps.person_id
2291: and PER.EMPLOYEE_NUMBER IS NOT NULL
2292: and PPS.DATE_START = (SELECT MAX(PPS1.DATE_START)

Line 2293: FROM PER_PERIODS_OF_SERVICE PPS1

2289: where per.person_id = v_person_id
2290: and per.person_id = pps.person_id
2291: and PER.EMPLOYEE_NUMBER IS NOT NULL
2292: and PPS.DATE_START = (SELECT MAX(PPS1.DATE_START)
2293: FROM PER_PERIODS_OF_SERVICE PPS1
2294: WHERE PPS1.PERSON_ID = PER.PERSON_ID
2295: AND PPS1.DATE_START <= PER.EFFECTIVE_END_DATE) ;
2296:
2297: -- pay period start date