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_PSU_BUS dependencies on HR_GENERAL

Line 676: l_mdpr := HR_GENERAL.end_of_time;

672: l_mtcd := TRUNC(l_mtcd+TRUNC(((ADD_MONTHS(l_mtcd,1)-l_mtcd)/2)));
673: END LOOP;
674: --
675: ELSE
676: l_mdpr := HR_GENERAL.end_of_time;
677: l_mtcd := HR_GENERAL.end_of_time;
678: END IF;
679: --
680: IF NVL(l_mdpr,l_start_date) = l_start_date THEN

Line 677: l_mtcd := HR_GENERAL.end_of_time;

673: END LOOP;
674: --
675: ELSE
676: l_mdpr := HR_GENERAL.end_of_time;
677: l_mtcd := HR_GENERAL.end_of_time;
678: END IF;
679: --
680: IF NVL(l_mdpr,l_start_date) = l_start_date THEN
681: l_mdpr := HR_GENERAL.end_of_time;

Line 681: l_mdpr := HR_GENERAL.end_of_time;

677: l_mtcd := HR_GENERAL.end_of_time;
678: END IF;
679: --
680: IF NVL(l_mdpr,l_start_date) = l_start_date THEN
681: l_mdpr := HR_GENERAL.end_of_time;
682: END IF;
683: --
684: IF NVL(l_mtcd,l_start_date) = l_start_date THEN
685: l_mtcd := HR_GENERAL.end_of_time;

Line 685: l_mtcd := HR_GENERAL.end_of_time;

681: l_mdpr := HR_GENERAL.end_of_time;
682: END IF;
683: --
684: IF NVL(l_mtcd,l_start_date) = l_start_date THEN
685: l_mtcd := HR_GENERAL.end_of_time;
686: END IF;
687: --
688: IF l_max_dur_per_renew IS NOT NULL AND NVL(p_rec.actual_end_date,p_rec.provisional_end_date) >= l_mdpr THEN
689: FND_MESSAGE.set_name ('PQH','FR_PQH_RENEW_OUT_OF_MAX_RANGE');

Line 735: Select nvl(date_to,hr_general.end_of_time)

731: where person_id = p_person_id
732: and trunc(sysdate) between effective_start_date and effective_end_date;
733: --
734: Cursor csr_situation_info IS
735: Select nvl(date_to,hr_general.end_of_time)
736: from pqh_fr_stat_situations
737: where statutory_situation_id = p_statutory_situation_id;
738: l_original_hire_date date;
739: l_situ_end_date date;

Line 781: AND business_group_id = HR_GENERAL.get_business_group_id

777: FROM pqh_fr_stat_situations
778: WHERE statutory_situation_id = p_rec.statutory_situation_id
779: AND situation_type = 'IA'
780: AND sub_type = 'IA_N'
781: AND business_group_id = HR_GENERAL.get_business_group_id
782: AND default_flag = 'Y'
783: AND TRUNC(SYSDATE) BETWEEN date_from AND NVL(date_to,HR_GENERAL.end_of_time));
784: --
785: CURSOR csr_overlap_dates(p_provisional_start DATE,

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

779: AND situation_type = 'IA'
780: AND sub_type = 'IA_N'
781: AND business_group_id = HR_GENERAL.get_business_group_id
782: AND default_flag = 'Y'
783: AND TRUNC(SYSDATE) BETWEEN date_from AND NVL(date_to,HR_GENERAL.end_of_time));
784: --
785: CURSOR csr_overlap_dates(p_provisional_start DATE,
786: p_provisional_end DATE,
787: p_actual_start DATE,

Line 804: AND sit.business_group_id = HR_GENERAL.get_business_group_id

800: FROM pqh_fr_stat_situations_v sit,
801: per_shared_types_vl sh
802: WHERE sh.shared_type_id = type_of_ps
803: AND sh.system_type_cd = NVL(PQH_FR_UTILITY.get_bg_type_of_ps,sh.system_type_cd)
804: AND sit.business_group_id = HR_GENERAL.get_business_group_id
805: AND sit.default_flag = 'Y'
806: AND sit.situation_type = 'IA'
807: AND sit.sub_type = 'IA_N'
808: AND TRUNC(SYSDATE) BETWEEN date_from AND NVL(date_to,HR_GENERAL.end_of_time))

Line 808: AND TRUNC(SYSDATE) BETWEEN date_from AND NVL(date_to,HR_GENERAL.end_of_time))

804: AND sit.business_group_id = HR_GENERAL.get_business_group_id
805: AND sit.default_flag = 'Y'
806: AND sit.situation_type = 'IA'
807: AND sit.sub_type = 'IA_N'
808: AND TRUNC(SYSDATE) BETWEEN date_from AND NVL(date_to,HR_GENERAL.end_of_time))
809: AND(NVL(p_actual_start,p_provisional_start) BETWEEN NVL(actual_start_date,provisional_start_date)
810: AND NVL(actual_end_date,NVL(provisional_end_date,hr_general.end_of_time))
811: OR NVL(p_actual_end,p_provisional_end) BETWEEN NVL(actual_end_date,provisional_end_date)
812: AND NVL(actual_end_date,NVL(provisional_end_date,hr_general.end_of_time))));

Line 810: AND NVL(actual_end_date,NVL(provisional_end_date,hr_general.end_of_time))

806: AND sit.situation_type = 'IA'
807: AND sit.sub_type = 'IA_N'
808: AND TRUNC(SYSDATE) BETWEEN date_from AND NVL(date_to,HR_GENERAL.end_of_time))
809: AND(NVL(p_actual_start,p_provisional_start) BETWEEN NVL(actual_start_date,provisional_start_date)
810: AND NVL(actual_end_date,NVL(provisional_end_date,hr_general.end_of_time))
811: OR NVL(p_actual_end,p_provisional_end) BETWEEN NVL(actual_end_date,provisional_end_date)
812: AND NVL(actual_end_date,NVL(provisional_end_date,hr_general.end_of_time))));
813: --
814: l_default_sit VARCHAR2(10);

Line 812: AND NVL(actual_end_date,NVL(provisional_end_date,hr_general.end_of_time))));

808: AND TRUNC(SYSDATE) BETWEEN date_from AND NVL(date_to,HR_GENERAL.end_of_time))
809: AND(NVL(p_actual_start,p_provisional_start) BETWEEN NVL(actual_start_date,provisional_start_date)
810: AND NVL(actual_end_date,NVL(provisional_end_date,hr_general.end_of_time))
811: OR NVL(p_actual_end,p_provisional_end) BETWEEN NVL(actual_end_date,provisional_end_date)
812: AND NVL(actual_end_date,NVL(provisional_end_date,hr_general.end_of_time))));
813: --
814: l_default_sit VARCHAR2(10);
815: l_valid VARCHAR2(10);
816: --

Line 1161: l_fpmd := HR_GENERAL.end_of_time;

1157: END LOOP;
1158: --
1159: ELSE
1160: --
1161: l_fpmd := HR_GENERAL.end_of_time;
1162: l_min_dpr := l_start_date;
1163: l_max_dpr := HR_GENERAL.end_of_time;
1164: l_mdwc := HR_GENERAL.end_of_time;
1165: --

Line 1163: l_max_dpr := HR_GENERAL.end_of_time;

1159: ELSE
1160: --
1161: l_fpmd := HR_GENERAL.end_of_time;
1162: l_min_dpr := l_start_date;
1163: l_max_dpr := HR_GENERAL.end_of_time;
1164: l_mdwc := HR_GENERAL.end_of_time;
1165: --
1166: END IF;
1167: --

Line 1164: l_mdwc := HR_GENERAL.end_of_time;

1160: --
1161: l_fpmd := HR_GENERAL.end_of_time;
1162: l_min_dpr := l_start_date;
1163: l_max_dpr := HR_GENERAL.end_of_time;
1164: l_mdwc := HR_GENERAL.end_of_time;
1165: --
1166: END IF;
1167: --
1168: IF NVL(l_fpmd,l_start_date) = l_start_date THEN

Line 1169: l_fpmd := HR_GENERAL.end_of_time;

1165: --
1166: END IF;
1167: --
1168: IF NVL(l_fpmd,l_start_date) = l_start_date THEN
1169: l_fpmd := HR_GENERAL.end_of_time;
1170: END IF;
1171: --
1172: IF NVL(l_mdwc,l_start_date) = l_start_date THEN
1173: l_mdwc := HR_GENERAL.end_of_time;

Line 1173: l_mdwc := HR_GENERAL.end_of_time;

1169: l_fpmd := HR_GENERAL.end_of_time;
1170: END IF;
1171: --
1172: IF NVL(l_mdwc,l_start_date) = l_start_date THEN
1173: l_mdwc := HR_GENERAL.end_of_time;
1174: END IF;
1175: --
1176: IF NVL(l_max_dpr,l_start_date) = l_start_date THEN
1177: l_max_dpr := HR_GENERAL.end_of_time;

Line 1177: l_max_dpr := HR_GENERAL.end_of_time;

1173: l_mdwc := HR_GENERAL.end_of_time;
1174: END IF;
1175: --
1176: IF NVL(l_max_dpr,l_start_date) = l_start_date THEN
1177: l_max_dpr := HR_GENERAL.end_of_time;
1178: END IF;
1179: --
1180: IF NVL(l_min_dpr,HR_GENERAL.end_of_time) = HR_GENERAL.end_of_time THEN
1181: l_min_dpr := l_start_date;

Line 1180: IF NVL(l_min_dpr,HR_GENERAL.end_of_time) = HR_GENERAL.end_of_time THEN

1176: IF NVL(l_max_dpr,l_start_date) = l_start_date THEN
1177: l_max_dpr := HR_GENERAL.end_of_time;
1178: END IF;
1179: --
1180: IF NVL(l_min_dpr,HR_GENERAL.end_of_time) = HR_GENERAL.end_of_time THEN
1181: l_min_dpr := l_start_date;
1182: END IF;
1183: --
1184: IF NVL(l_previous_exist,'N') = 'Y' THEN --If Situation exists.