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

Line 428: IF p_start_date > NVL(p_end_date, hr_general.END_OF_TIME) THEN

424: END IF;
425: --
426: -- check that the start date is not on or more than the end date
427: --
428: IF p_start_date > NVL(p_end_date, hr_general.END_OF_TIME) THEN
429: --
430: hr_utility.set_message
431: (800
432: ,'PER_52525_ASP_DATE_ERROR'

Line 504: AND NVL(s.end_date, hr_general.END_OF_TIME) <= NVL(p_end_date, hr_general.END_OF_TIME)

500: AND s.security_group_id = p_security_group_id
501: AND s.business_group_id = p_business_group_id
502: AND s.security_profile_id = p_security_profile_id
503: AND s.start_date >= p_start_date
504: AND NVL(s.end_date, hr_general.END_OF_TIME) <= NVL(p_end_date, hr_general.END_OF_TIME)
505: AND (p_sec_profile_assignment_id IS NULL
506: OR s.sec_profile_assignment_id <> p_sec_profile_assignment_id);
507: --
508: l_result VARCHAR2 (1);

Line 568: AND NVL(p_end_date, hr_general.END_OF_TIME))

564: AND security_group_id = p_security_group_id
565: AND business_group_id = p_business_group_id
566: AND security_profile_id <> p_security_profile_id
567: AND ( (start_date BETWEEN p_start_date
568: AND NVL(p_end_date, hr_general.END_OF_TIME))
569: OR (NVL(end_date, hr_general.END_OF_TIME)
570: BETWEEN p_start_date
571: AND NVL(p_end_date, hr_general.END_OF_TIME))
572: OR ( start_date < p_start_date

Line 569: OR (NVL(end_date, hr_general.END_OF_TIME)

565: AND business_group_id = p_business_group_id
566: AND security_profile_id <> p_security_profile_id
567: AND ( (start_date BETWEEN p_start_date
568: AND NVL(p_end_date, hr_general.END_OF_TIME))
569: OR (NVL(end_date, hr_general.END_OF_TIME)
570: BETWEEN p_start_date
571: AND NVL(p_end_date, hr_general.END_OF_TIME))
572: OR ( start_date < p_start_date
573: AND NVL(end_date, hr_general.END_OF_TIME)

Line 571: AND NVL(p_end_date, hr_general.END_OF_TIME))

567: AND ( (start_date BETWEEN p_start_date
568: AND NVL(p_end_date, hr_general.END_OF_TIME))
569: OR (NVL(end_date, hr_general.END_OF_TIME)
570: BETWEEN p_start_date
571: AND NVL(p_end_date, hr_general.END_OF_TIME))
572: OR ( start_date < p_start_date
573: AND NVL(end_date, hr_general.END_OF_TIME)
574: > NVL(p_end_date, hr_general.END_OF_TIME)));
575: --

Line 573: AND NVL(end_date, hr_general.END_OF_TIME)

569: OR (NVL(end_date, hr_general.END_OF_TIME)
570: BETWEEN p_start_date
571: AND NVL(p_end_date, hr_general.END_OF_TIME))
572: OR ( start_date < p_start_date
573: AND NVL(end_date, hr_general.END_OF_TIME)
574: > NVL(p_end_date, hr_general.END_OF_TIME)));
575: --
576: l_exists VARCHAR2(1);
577: --

Line 574: > NVL(p_end_date, hr_general.END_OF_TIME)));

570: BETWEEN p_start_date
571: AND NVL(p_end_date, hr_general.END_OF_TIME))
572: OR ( start_date < p_start_date
573: AND NVL(end_date, hr_general.END_OF_TIME)
574: > NVL(p_end_date, hr_general.END_OF_TIME)));
575: --
576: l_exists VARCHAR2(1);
577: --
578: BEGIN

Line 731: AND NVL(s.end_date, hr_general.END_OF_TIME) < p_start_date)

727: AND s.security_group_id = p_security_group_id
728: AND s.business_group_id = p_business_group_id
729: AND s.security_profile_id = p_security_profile_id
730: AND NOT ( (s.start_date < p_start_date
731: AND NVL(s.end_date, hr_general.END_OF_TIME) < p_start_date)
732: OR (s.start_date > p_end_date
733: AND NVL(s.end_date, hr_general.END_OF_TIME) > NVL(p_end_date, hr_general.END_OF_TIME))
734: )
735: AND (p_sec_profile_assignment_id IS NULL

Line 733: AND NVL(s.end_date, hr_general.END_OF_TIME) > NVL(p_end_date, hr_general.END_OF_TIME))

729: AND s.security_profile_id = p_security_profile_id
730: AND NOT ( (s.start_date < p_start_date
731: AND NVL(s.end_date, hr_general.END_OF_TIME) < p_start_date)
732: OR (s.start_date > p_end_date
733: AND NVL(s.end_date, hr_general.END_OF_TIME) > NVL(p_end_date, hr_general.END_OF_TIME))
734: )
735: AND (p_sec_profile_assignment_id IS NULL
736: OR s.sec_profile_assignment_id <> p_sec_profile_assignment_id);
737: --

Line 1125: l_max_date := hr_general.END_OF_TIME;

1121: --
1122: -- A record that has not been end-dated exists..
1123: -- So set the end date in the fnd_user_resp_groups table to be the
1124: -- end of time...
1125: l_max_date := hr_general.END_OF_TIME;
1126: END IF;
1127:
1128: CLOSE c_chk_null_end_date;
1129: --