DBA Data[Home] [Help]

APPS.PAY_IN_REPORTS_PKG dependencies on PER_DISABILITIES_F

Line 2652: FROM per_disabilities_f pdf,

2648:
2649: /*Cursor to get the disable proof details */
2650: CURSOR c_disable_proof is
2651: SELECT pdf.dis_information1
2652: FROM per_disabilities_f pdf,
2653: per_assignments_f paf
2654: WHERE paf.assignment_id = p_assignment_id
2655: AND paf.person_id = pdf.person_id
2656: AND p_earn_date BETWEEN paf.effective_start_date AND paf.effective_end_date

Line 2681: l_disable_proof per_disabilities_f.dis_information1%TYPE;

2677: WHERE p_earn_date BETWEEN ASSIGN.effective_start_date AND assign.effective_end_date
2678: AND assign.assignment_id = p_assignment_id
2679: AND service.period_of_service_id (+)= assign.period_of_service_id;
2680:
2681: l_disable_proof per_disabilities_f.dis_information1%TYPE;
2682: l_emplr_class hr_organization_information.org_information3%TYPE;
2683: l_hire_date date;
2684: l_ceiling_type varchar2(50);
2685: