APPS.PSP_ENC_SUM_TRAN dependencies on PER_ALL_ASSIGNMENTS_F

Line 6849: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

6845: PROCEDURE log_st_warnings IS
6846: l_request_id NUMBER(15);
6847: l_person_id NUMBER(15);
6848: l_organization_id NUMBER(15);
6849: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
6850: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
6851: l_full_name per_all_people_f.full_name%TYPE;
6852: l_organization_name hr_organization_units.name%TYPE;
6853: l_element_name pay_element_types_f.element_name%TYPE;

Line 6867: FROM per_all_assignments_f

6863: p_effective_date IN DATE) IS
6864: SELECT assignment_number,
6865: person_id,
6866: organization_id
6867: FROM per_all_assignments_f
6868: WHERE assignment_id = p_assignment_id
6869: AND payroll_id = p_payroll_id
6870: AND effective_end_date >= p_effective_date
6871: AND ROWNUM = 1;