APPS.PAY_IN_REPORTS_PKG dependencies on PER_DISABILITIES_F

Line 2071: FROM per_disabilities_f pdf,

2067:
2068: /*Cursor to get the disable proof details */
2069: CURSOR c_disable_proof is
2070: SELECT pdf.dis_information1
2071: FROM per_disabilities_f pdf,
2072: per_assignments_f paf
2073: WHERE paf.assignment_id = p_assignment_id
2074: AND paf.person_id = pdf.person_id
2075: AND p_earn_date BETWEEN paf.effective_start_date AND paf.effective_end_date

Line 2100: l_disable_proof per_disabilities_f.dis_information1%TYPE;

2096: WHERE p_earn_date BETWEEN ASSIGN.effective_start_date AND assign.effective_end_date
2097: AND assign.assignment_id = p_assignment_id
2098: AND service.period_of_service_id (+)= assign.period_of_service_id;
2099:
2100: l_disable_proof per_disabilities_f.dis_information1%TYPE;
2101: l_emplr_class hr_organization_information.org_information3%TYPE;
2102: l_hire_date date;
2103: l_ceiling_type varchar2(50);
2104: