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

Line 293: and p_determination_date between date_start and nvl(date_end,hr_general.end_of_time);

289: begin
290: select count(1) into l_dependent_cnt
291: from per_contact_relationships
292: where person_id = p_person_id
293: and p_determination_date between date_start and nvl(date_end,hr_general.end_of_time);
294: if l_dependent_cnt = 0 then
295: return null;
296: else
297: select max(date_of_birth) into l_dependent_dob

Line 302: and p_determination_date between date_start and nvl(date_end,hr_general.end_of_time));

298: from per_all_people_f
299: where person_id in (select contact_person_id
300: from per_contact_relationships
301: where person_id = p_person_id
302: and p_determination_date between date_start and nvl(date_end,hr_general.end_of_time));
303: l_dependent_age := Months_Between(p_determination_date,l_dependent_dob)/12;
304: return l_dependent_age;
305: end if;
306: end;

Line 613: AND TRUNC(p_eff_date) BETWEEN sit.date_from AND NVL(sit.date_to,HR_GENERAL.end_of_time);

609: AND sit.business_group_id = p_business_group_id
610: AND sit.situation_type = p_situation_type
611: AND sit.sub_type = NVL(p_sub_type,sub_type)
612: AND sit.default_flag = 'Y'
613: AND TRUNC(p_eff_date) BETWEEN sit.date_from AND NVL(sit.date_to,HR_GENERAL.end_of_time);
614: /* --Commented by deenath and replaced by above cursor sql.
615: SELECT statutory_situation_id
616: FROM pqh_fr_stat_situations
617: WHERE business_group_id = p_business_group_id

Line 621: AND trunc(p_eff_date) BETWEEN date_from and NVL(date_to,hr_general.end_of_time);

617: WHERE business_group_id = p_business_group_id
618: AND situation_type = p_situation_type
619: AND sub_type = NVL(p_sub_type,sub_type)
620: AND default_flag = 'Y'
621: AND trunc(p_eff_date) BETWEEN date_from and NVL(date_to,hr_general.end_of_time);
622: */
623: l_reinstate_situation NUMBER(15);
624: BEGIN
625: OPEN csr_dflt_inactivity(p_business_group_id,p_situation_type,p_sub_type,p_effective_date);

Line 637: If p_provisional_end_date = hr_general.end_of_time then

633: p_effective_date IN DATE)
634: RETURN VARCHAR2 IS
635: BEGIN
636: /* --Commented by deenath to display Timeline even for End Of Time Situations.
637: If p_provisional_end_date = hr_general.end_of_time then
638: Return null;
639: End if;
640: */
641: IF p_effective_date BETWEEN p_provisional_start_date AND p_provisional_end_date THEN

Line 642: RETURN HR_GENERAL.decode_lookup('PQH_FR_SIT_TIME_LINES','PRESENT');

638: Return null;
639: End if;
640: */
641: IF p_effective_date BETWEEN p_provisional_start_date AND p_provisional_end_date THEN
642: RETURN HR_GENERAL.decode_lookup('PQH_FR_SIT_TIME_LINES','PRESENT');
643: ELSIF p_effective_date > p_provisional_end_date THEN
644: RETURN HR_GENERAL.decode_lookup('PQH_FR_SIT_TIME_LINES','PAST');
645: ELSIF p_provisional_start_date > p_effective_date Then
646: RETURN HR_GENERAL.decode_lookup('PQH_FR_SIT_TIME_LINES','FUTURE');

Line 644: RETURN HR_GENERAL.decode_lookup('PQH_FR_SIT_TIME_LINES','PAST');

640: */
641: IF p_effective_date BETWEEN p_provisional_start_date AND p_provisional_end_date THEN
642: RETURN HR_GENERAL.decode_lookup('PQH_FR_SIT_TIME_LINES','PRESENT');
643: ELSIF p_effective_date > p_provisional_end_date THEN
644: RETURN HR_GENERAL.decode_lookup('PQH_FR_SIT_TIME_LINES','PAST');
645: ELSIF p_provisional_start_date > p_effective_date Then
646: RETURN HR_GENERAL.decode_lookup('PQH_FR_SIT_TIME_LINES','FUTURE');
647: END IF;
648: RETURN NULL; --added by deenath

Line 646: RETURN HR_GENERAL.decode_lookup('PQH_FR_SIT_TIME_LINES','FUTURE');

642: RETURN HR_GENERAL.decode_lookup('PQH_FR_SIT_TIME_LINES','PRESENT');
643: ELSIF p_effective_date > p_provisional_end_date THEN
644: RETURN HR_GENERAL.decode_lookup('PQH_FR_SIT_TIME_LINES','PAST');
645: ELSIF p_provisional_start_date > p_effective_date Then
646: RETURN HR_GENERAL.decode_lookup('PQH_FR_SIT_TIME_LINES','FUTURE');
647: END IF;
648: RETURN NULL; --added by deenath
649: END get_time_line;
650: --

Line 658: IF p_provisional_end_date = HR_GENERAL.end_of_time OR p_actual_end_date = HR_GENERAL.end_of_time THEN

654: p_effective_date IN DATE) RETURN VARCHAR2
655: IS
656: BEGIN
657: --
658: IF p_provisional_end_date = HR_GENERAL.end_of_time OR p_actual_end_date = HR_GENERAL.end_of_time THEN
659: RETURN NULL;
660: END IF;
661: --
662: IF p_actual_end_date IS NOT NULL THEN

Line 726: IF p_provisional_end_date = hr_general.end_of_time THEN

722: p_effective_date IN DATE)
723: RETURN VARCHAR2 IS
724: l_return_value VARCHAR2(10) := NULL;
725: BEGIN
726: IF p_provisional_end_date = hr_general.end_of_time THEN
727: RETURN NULL;
728: END IF;
729: IF p_effective_date BETWEEN p_provisional_start_date AND p_provisional_end_date THEN
730: RETURN NULL;

Line 744: AND sit.business_group_id= HR_GENERAL.get_business_group_id

740: FROM pqh_fr_stat_situations_v sit
741: ,per_shared_types_vl sh
742: WHERE sh.shared_type_id = type_of_ps
743: AND sh.system_type_cd = NVL(PQH_FR_UTILITY.get_bg_type_of_ps,sh.system_type_cd)
744: AND sit.business_group_id= HR_GENERAL.get_business_group_id
745: AND sit.default_flag = 'Y'
746: AND sit.situation_type = 'IA'
747: AND sit.sub_type = 'IA_N'
748: AND TRUNC(SYSDATE) BETWEEN sit.date_from AND NVL(sit.date_to,HR_GENERAL.end_of_time));

Line 748: AND TRUNC(SYSDATE) BETWEEN sit.date_from AND NVL(sit.date_to,HR_GENERAL.end_of_time));

744: AND sit.business_group_id= HR_GENERAL.get_business_group_id
745: AND sit.default_flag = 'Y'
746: AND sit.situation_type = 'IA'
747: AND sit.sub_type = 'IA_N'
748: AND TRUNC(SYSDATE) BETWEEN sit.date_from AND NVL(sit.date_to,HR_GENERAL.end_of_time));
749: END IF;
750: RETURN l_return_value;
751: END get_delete_time_line_code;
752: --