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.HR_CAU_BUS dependencies on HR_GENERAL

Line 387: and p_start_date < nvl (inactive_date, hr_general.end_of_time);

383: --
384: select 1
385: from hr_locations
386: where location_id = p_primary_key_value
387: and p_start_date < nvl (inactive_date, hr_general.end_of_time);
388: --
389: cursor csr_job is
390: --
391: -- Check for a valid job id

Line 397: and nvl (date_to, hr_general.end_of_time);

393: select 1
394: from per_jobs
395: where job_id = p_primary_key_value
396: and p_start_date between date_from
397: and nvl (date_to, hr_general.end_of_time);
398: --
399: cursor csr_organization is
400: --
401: -- Check for a valid organization id

Line 407: and nvl (date_to, hr_general.end_of_time);

403: select 1
404: from per_business_groups_perf
405: where business_group_id = p_primary_key_value
406: and p_start_date between date_from
407: and nvl (date_to, hr_general.end_of_time);
408: --
409: cursor csr_position is
410: --
411: -- Check for a valid position id

Line 418: and nvl (hr_general.get_position_date_end(position_id), hr_general.end_of_time);

414: select 1
415: from hr_positions_f
416: where position_id = p_primary_key_value
417: and p_start_date between date_effective
418: and nvl (hr_general.get_position_date_end(position_id), hr_general.end_of_time);
419: --
420: cursor csr_entity_name is
421: --
422: -- Get the entity name for the pattern purpose usage