eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 790: per_person_type_usages_f pptf

786: CURSOR fptypes_for_cwk1 IS
787: SELECT ppt.system_person_type
788: FROM
789: per_person_types ppt ,
790: per_person_type_usages_f pptf
791: WHERE
792: pptf.person_id = p_person_id
793: AND p_action_date < pptf.effective_start_date
794: AND pptf.person_type_id = ppt.person_type_id

Line 3383: l_per_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;

3379: --
3380: -- Changes start for the Bug#13571033
3381:
3382: l_sys_per_type per_person_types.system_person_type%TYPE;
3383: l_per_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
3384: l_ovn per_person_type_usages_f.object_version_number%TYPE;
3385: l_eff_start_date per_person_type_usages_f.effective_start_date%TYPE;
3386: l_eff_end_date per_person_type_usages_f.effective_end_date%TYPE;
3387:

Line 3384: l_ovn per_person_type_usages_f.object_version_number%TYPE;

3380: -- Changes start for the Bug#13571033
3381:
3382: l_sys_per_type per_person_types.system_person_type%TYPE;
3383: l_per_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
3384: l_ovn per_person_type_usages_f.object_version_number%TYPE;
3385: l_eff_start_date per_person_type_usages_f.effective_start_date%TYPE;
3386: l_eff_end_date per_person_type_usages_f.effective_end_date%TYPE;
3387:
3388: -- Changes end for the Bug#13571033

Line 3385: l_eff_start_date per_person_type_usages_f.effective_start_date%TYPE;

3381:
3382: l_sys_per_type per_person_types.system_person_type%TYPE;
3383: l_per_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
3384: l_ovn per_person_type_usages_f.object_version_number%TYPE;
3385: l_eff_start_date per_person_type_usages_f.effective_start_date%TYPE;
3386: l_eff_end_date per_person_type_usages_f.effective_end_date%TYPE;
3387:
3388: -- Changes end for the Bug#13571033
3389: --

Line 3386: l_eff_end_date per_person_type_usages_f.effective_end_date%TYPE;

3382: l_sys_per_type per_person_types.system_person_type%TYPE;
3383: l_per_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
3384: l_ovn per_person_type_usages_f.object_version_number%TYPE;
3385: l_eff_start_date per_person_type_usages_f.effective_start_date%TYPE;
3386: l_eff_end_date per_person_type_usages_f.effective_end_date%TYPE;
3387:
3388: -- Changes end for the Bug#13571033
3389: --
3390: -- start of bug 4919804

Line 3499: FROM per_person_type_usages_f ptu,

3495: -- Changes start for the bug 13571033
3496:
3497: CURSOR csr_is_end_apl IS
3498: SELECT pt.system_person_type
3499: FROM per_person_type_usages_f ptu,
3500: per_person_types pt
3501: WHERE ptu.person_id = p_person_id
3502: AND pt.person_type_id = ptu.person_type_Id
3503: AND pt.system_person_type = 'EX_APL'

Line 3508: FROM per_person_type_usages_f ptu,

3504: AND ptu.effective_start_date = p_actual_termination_date+1 ;
3505:
3506: CURSOR csr_emp_ptu_info IS
3507: SELECT ptu.person_type_usage_id, ptu.object_version_number
3508: FROM per_person_type_usages_f ptu,
3509: per_person_types ppt
3510: WHERE ptu.person_id = p_person_id
3511: AND ptu.person_type_id = ppt.person_type_id
3512: AND ppt.system_person_type = 'EMP'