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 2388: per_periods_of_service pps

2384: select pps.date_start,
2385: pps.adjusted_svc_date,
2386: ppf.original_date_of_hire
2387: from per_all_people_f ppf,
2388: per_periods_of_service pps
2389: where pps.person_id(+) = ppf.person_id
2390: and ppf.person_id = p_person_id
2391: and ppf.business_group_id = p_business_group_id
2392: and l_effective_date

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

2391: and ppf.business_group_id = p_business_group_id
2392: and l_effective_date
2393: between ppf.effective_start_date
2394: and ppf.effective_end_date
2395: --Bug2168233 to get the right record from per_periods_of_service
2396: and l_effective_date >= pps.date_start(+) /*Bug 2973791 outer join added*/
2397: order by pps.date_start desc ;
2398: --
2399: l_person c_person%rowtype;