APPS.PSP_PAYTRN dependencies on PER_PEOPLE_F

Line 1004: FROM per_people_f

1000: FETCH exp_org_cur INTO l_or_expenditure_org_name;
1001: IF (exp_org_cur%NOTFOUND) THEN
1002: SELECT full_name
1003: INTO l_employee_name
1004: FROM per_people_f
1005: WHERE person_id = l_person_id
1006: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1007: l_value := 'Organization Id = ' || TO_CHAR(l_or_expenditure_org_id);
1008: l_table := 'HR_ORGANIZATION_UNITS';

Line 1024: FROM per_people_f

1020: FETCH project_id_cur INTO l_project_number;
1021: IF (project_id_cur%NOTFOUND) THEN
1022: SELECT full_name
1023: INTO l_employee_name
1024: FROM per_people_f
1025: WHERE person_id = l_person_id
1026: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1027: l_value := 'Project Id = ' || TO_CHAR(l_or_project_id);
1028: l_table := 'PA_PROJECTS_ALL';

Line 1044: FROM per_people_f

1040: FETCH org_id_cur INTO l_org_id;
1041: IF (org_id_cur%NOTFOUND) THEN
1042: SELECT full_name
1043: INTO l_employee_name
1044: FROM per_people_f
1045: WHERE person_id = l_person_id
1046: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1047: l_value := 'Project Id = ' || TO_CHAR(l_or_project_id);
1048: l_table := 'PA_PROJECTS_ALL';

Line 1064: FROM per_people_f

1060: FETCH task_id_cur INTO l_task_number;
1061: IF (task_id_cur%NOTFOUND) THEN
1062: SELECT full_name
1063: INTO l_employee_name
1064: FROM per_people_f
1065: WHERE person_id = l_person_id
1066: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1067: l_value := 'TaskId = ' || TO_CHAR(l_or_task_id);
1068: l_table := 'PA_TASKS';

Line 1085: FROM per_people_f

1081: FETCH award_id_cur INTO l_award_number;
1082: IF (award_id_cur%NOTFOUND) THEN
1083: SELECT full_name
1084: INTO l_employee_name
1085: FROM per_people_f
1086: WHERE person_id = l_person_id
1087: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1088: l_value := 'Award Id = ' || TO_CHAR(l_or_award_id);
1089: l_table := 'GMS_AWARDS_ALL';

Line 1106: FROM per_people_f

1102: FETCH expenditure_type_cur INTO l_award_number;
1103: IF (expenditure_type_cur%NOTFOUND) THEN
1104: SELECT full_name
1105: INTO l_employee_name
1106: FROM per_people_f
1107: WHERE person_id = l_person_id
1108: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1109: l_value := 'Expenditure Type = ' || l_or_expenditure_type;
1110: l_table := 'PA_EXPENDITURE_TYPES';

Line 1389: from per_people_f

1385:
1386: IF l_gms_posting_date is null then
1387: select distinct substr(full_name,1,50)
1388: into l_employee_name
1389: from per_people_f
1390: where person_id = l_person_id and
1391: g_pay_costs_rec.date_earned between effective_start_date and effective_end_date;
1392: FND_MESSAGE.Set_Name('PSP', 'PSP_PI_PRMRY_ASG_INACTIVE');
1393: FND_MESSAGE.set_token('Employee',l_employee_name);

Line 1805: select distinct substr(full_name,1,50) into l_employee_name from per_people_f

1801:
1802: return;
1803: WHEN NO_DATA_FOUND then
1804: close get_pay_costs_csr;
1805: select distinct substr(full_name,1,50) into l_employee_name from per_people_f
1806: --where person_id = l_person_id; /* Tar#12269298 WVU */
1807: where person_id = l_person_id and
1808: effective_start_date = (select max(effective_start_date ) from per_people_f where
1809: person_id=l_person_id);

Line 1808: effective_start_date = (select max(effective_start_date ) from per_people_f where

1804: close get_pay_costs_csr;
1805: select distinct substr(full_name,1,50) into l_employee_name from per_people_f
1806: --where person_id = l_person_id; /* Tar#12269298 WVU */
1807: where person_id = l_person_id and
1808: effective_start_date = (select max(effective_start_date ) from per_people_f where
1809: person_id=l_person_id);
1810: /* Changed in lieu of caltech's reporting, that an employee terminated on the last day was not getting paid
1811:
1812: