DBA Data[Home] [Help]

APPS.HREMPTER dependencies on PER_PERSON_TYPE_USAGES_F

Line 300: modified to query from per_person_type_usages_f table.

296: terminate_entries_and_alus procedure
297: modified to increase performance.
298: 115.54 16-Jun-2005 ghshanka 4436297 cursor 'future_person_types'
299: in the funtion 'check_for_future_person_type' is
300: modified to query from per_person_type_usages_f table.
301: 115.55 27-jun-2005 njaladi Backed out changes done in 115.54 and this version
302: is same as 115.53.
303: 115.58 13-Jan-2006 ghshanka 4919804 Modified the procedure cancel_termination to call
304: the procedure pay_pog_all_assignments_pkg.after_delete

Line 778: per_person_type_usages_f pptf

774: CURSOR fptypes_for_cwk1 IS
775: SELECT ppt.system_person_type
776: FROM
777: per_person_types ppt ,
778: per_person_type_usages_f pptf
779: WHERE
780: pptf.person_id = p_person_id
781: AND p_action_date < pptf.effective_start_date
782: AND pptf.person_type_id = ppt.person_type_id