APPS.PSP_PAYTRN dependencies on PER_PEOPLE_F

Line 1037: FROM per_people_f

1033: FETCH exp_org_cur INTO l_or_expenditure_org_name;
1034: IF (exp_org_cur%NOTFOUND) THEN
1035: SELECT full_name
1036: INTO l_employee_name
1037: FROM per_people_f
1038: WHERE person_id = l_person_id
1039: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1040: l_value := 'Organization Id = ' || TO_CHAR(l_or_expenditure_org_id);
1041: l_table := 'HR_ORGANIZATION_UNITS';

Line 1057: FROM per_people_f

1053: FETCH project_id_cur INTO l_project_number;
1054: IF (project_id_cur%NOTFOUND) THEN
1055: SELECT full_name
1056: INTO l_employee_name
1057: FROM per_people_f
1058: WHERE person_id = l_person_id
1059: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1060: l_value := 'Project Id = ' || TO_CHAR(l_or_project_id);
1061: l_table := 'PA_PROJECTS_ALL';

Line 1077: FROM per_people_f

1073: FETCH org_id_cur INTO l_org_id;
1074: IF (org_id_cur%NOTFOUND) THEN
1075: SELECT full_name
1076: INTO l_employee_name
1077: FROM per_people_f
1078: WHERE person_id = l_person_id
1079: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1080: l_value := 'Project Id = ' || TO_CHAR(l_or_project_id);
1081: l_table := 'PA_PROJECTS_ALL';

Line 1097: FROM per_people_f

1093: FETCH task_id_cur INTO l_task_number;
1094: IF (task_id_cur%NOTFOUND) THEN
1095: SELECT full_name
1096: INTO l_employee_name
1097: FROM per_people_f
1098: WHERE person_id = l_person_id
1099: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1100: l_value := 'TaskId = ' || TO_CHAR(l_or_task_id);
1101: l_table := 'PA_TASKS';

Line 1118: FROM per_people_f

1114: FETCH award_id_cur INTO l_award_number;
1115: IF (award_id_cur%NOTFOUND) THEN
1116: SELECT full_name
1117: INTO l_employee_name
1118: FROM per_people_f
1119: WHERE person_id = l_person_id
1120: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1121: l_value := 'Award Id = ' || TO_CHAR(l_or_award_id);
1122: l_table := 'GMS_AWARDS_ALL';

Line 1139: FROM per_people_f

1135: FETCH expenditure_type_cur INTO l_award_number;
1136: IF (expenditure_type_cur%NOTFOUND) THEN
1137: SELECT full_name
1138: INTO l_employee_name
1139: FROM per_people_f
1140: WHERE person_id = l_person_id
1141: AND g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;
1142: l_value := 'Expenditure Type = ' || l_or_expenditure_type;
1143: l_table := 'PA_EXPENDITURE_TYPES';

Line 1442: from per_people_f

1438: hr_utility.trace('I might fail now');
1439:
1440: select distinct substr(full_name,1,50)
1441: into l_employee_name
1442: from per_people_f
1443: where person_id = l_person_id and
1444: g_pay_costs_rec.date_earned between effective_start_date and effective_end_date;
1445:
1446: hr_utility.trace('Am i successful');

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

1870: hr_utility.trace('-exception 10- close check_payroll_lines_csr');
1871: close check_payroll_lines_csr;
1872: END IF;
1873:
1874: select distinct substr(full_name,1,50) into l_employee_name from per_people_f
1875: --where person_id = l_person_id; /* Tar#12269298 WVU */
1876: where person_id = l_person_id and
1877: effective_start_date = (select max(effective_start_date ) from per_people_f where
1878: person_id=l_person_id);

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

1873:
1874: select distinct substr(full_name,1,50) into l_employee_name from per_people_f
1875: --where person_id = l_person_id; /* Tar#12269298 WVU */
1876: where person_id = l_person_id and
1877: effective_start_date = (select max(effective_start_date ) from per_people_f where
1878: person_id=l_person_id);
1879: /* Changed in lieu of caltech's reporting, that an employee terminated on the last day was not getting paid
1880:
1881: