APPS.PSP_ENC_SUM_TRAN dependencies on PER_ALL_ASSIGNMENTS_F

Line 7085: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

7081: PROCEDURE log_st_warnings IS
7082: l_request_id NUMBER(15);
7083: l_person_id NUMBER(15);
7084: l_organization_id NUMBER(15);
7085: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
7086: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
7087: l_full_name per_all_people_f.full_name%TYPE;
7088: l_organization_name hr_organization_units.name%TYPE;
7089: l_element_name pay_element_types_f.element_name%TYPE;

Line 7103: FROM per_all_assignments_f

7099: p_effective_date IN DATE) IS
7100: SELECT assignment_number,
7101: person_id,
7102: organization_id
7103: FROM per_all_assignments_f
7104: WHERE assignment_id = p_assignment_id
7105: AND payroll_id = p_payroll_id
7106: AND effective_end_date >= p_effective_date
7107: AND ROWNUM = 1;