APPS.PQP_GB_PSI_STH_HISTORY dependencies on HR_API

Line 796: and NVL(per.effective_end_date,hr_api.g_eot)

792: from per_all_people_f PER, per_periods_of_service PPS
793: where per.person_id = g_person_id
794: and pps.person_id = g_person_id
795: and p_effective_date between per.effective_start_date
796: and NVL(per.effective_end_date,hr_api.g_eot)
797: and p_effective_date between pps.date_start
798: and NVL(pps.final_process_date,hr_api.g_eot);
799:
800: BEGIN -- set_assignment_globals

Line 798: and NVL(pps.final_process_date,hr_api.g_eot);

794: and pps.person_id = g_person_id
795: and p_effective_date between per.effective_start_date
796: and NVL(per.effective_end_date,hr_api.g_eot)
797: and p_effective_date between pps.date_start
798: and NVL(pps.final_process_date,hr_api.g_eot);
799:
800: BEGIN -- set_assignment_globals
801: debug_enter(l_proc);
802: debug('Inputs are: ',10);

Line 1154: IF NVL(g_start_date,hr_api.g_eot) > l_claim_date_dt THEN

1150: debug('assign the claim date to g_effective_date for SINGLE records',40);
1151: g_effective_date := l_claim_date_dt;
1152: debug('g_effective_date: '||g_effective_date);
1153: ELSE -- ACCUMULATED Records
1154: IF NVL(g_start_date,hr_api.g_eot) > l_claim_date_dt THEN
1155: debug(l_claim_date_dt||' is less than '||g_start_date,50);
1156: g_start_date := l_claim_date_dt;
1157: END IF;
1158: IF NVL(g_end_date,hr_api.g_sot) < l_claim_date_dt THEN

Line 1158: IF NVL(g_end_date,hr_api.g_sot) < l_claim_date_dt THEN

1154: IF NVL(g_start_date,hr_api.g_eot) > l_claim_date_dt THEN
1155: debug(l_claim_date_dt||' is less than '||g_start_date,50);
1156: g_start_date := l_claim_date_dt;
1157: END IF;
1158: IF NVL(g_end_date,hr_api.g_sot) < l_claim_date_dt THEN
1159: debug(l_claim_date_dt||' is greater than '||g_end_date,50);
1160: g_end_date := l_claim_date_dt;
1161: END IF;
1162: debug('g_start_date: '||g_start_date,40);