APPS.BEN_DERIVE_FACTORS dependencies on PER_PERIODS_OF_SERVICE

Line 175: 14-JUL-2003 glingapp 115.70 added outer join on per_periods_of_service in

171: Added a check on effective dates while
172: picking up details of the person's spouse
173: The same chk has been added to all cursors
174: using per_contact_relationships
175: 14-JUL-2003 glingapp 115.70 added outer join on per_periods_of_service in
176: cursor c_person of determine_los
177: 24-Sep-2003 ikasire 115.71 Bug 3151737 - made the join to pay_all_payrolls_f
178: as outer join and added the effective date
179: clause for the same table.

Line 2268: per_periods_of_service pps

2264: select pps.date_start,
2265: pps.adjusted_svc_date,
2266: ppf.original_date_of_hire
2267: from per_all_people_f ppf,
2268: per_periods_of_service pps
2269: where pps.person_id(+) = ppf.person_id
2270: and ppf.person_id = p_person_id
2271: and ppf.business_group_id = p_business_group_id
2272: and l_effective_date

Line 2275: --Bug2168233 to get the right record from per_periods_of_service

2271: and ppf.business_group_id = p_business_group_id
2272: and l_effective_date
2273: between ppf.effective_start_date
2274: and ppf.effective_end_date
2275: --Bug2168233 to get the right record from per_periods_of_service
2276: and l_effective_date >= pps.date_start(+) /*Bug 2973791 outer join added*/
2277: order by pps.date_start desc ;
2278: --
2279: l_person c_person%rowtype;