APPS.PAY_IN_REPORTS_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 41: FROM per_assignment_extra_info

37:
38: CURSOR c_remarks
39: IS
40: SELECT aei_information3
41: FROM per_assignment_extra_info
42: WHERE aei_information2 = LPAD(p_mon,2,'0')
43: AND aei_information1 = p_period
44: AND information_type = DECODE(p_report_type,'PF','PER_IN_PF_REMARKS','ESI','PER_IN_ESI_REMARKS')
45: AND assignment_id IN(SELECT DISTINCT pea.assignment_id