APPS.PAY_SE_PAYSLIP_REPORT dependencies on PER_ALL_ASSIGNMENTS_F

Line 358: FROM PER_ALL_ASSIGNMENTS_F PAF,

354:
355: CURSOR csr_assg_id(p_payroll_id NUMBER,p_start_date VARCHAR2, p_end_date VARCHAR2)
356: IS
357: SELECT PAF.ASSIGNMENT_ID assignment_id
358: FROM PER_ALL_ASSIGNMENTS_F PAF,
359: PAY_ASSIGNMENT_ACTIONS PAA,
360: PAY_PAYROLL_ACTIONS PPA
361: WHERE PAF.payroll_id=p_payroll_id
362: AND PPA.PAYROLL_ACTION_ID=PAA.PAYROLL_ACTION_ID

Line 385: per_all_assignments_f PAA ,

381: CURSOR csr_local_unit_id(p_assignment_id NUMBER, p_effective_date DATE) IS
382: SELECT SCL.segment2 local_unit_id
383: , business_group_id
384: FROM
385: per_all_assignments_f PAA ,
386: hr_soft_coding_keyflex SCL
387: WHERE ASSIGNMENT_ID = p_assignment_id
388: AND PAA.soft_coding_keyflex_id = SCL.soft_coding_keyflex_id
389: AND p_effective_date BETWEEN PAA.effective_start_date AND PAA.effective_end_date ;