DBA Data[Home] [Help]

APPS.PAY_ES_TWR_CALC_PKG dependencies on PER_DISABILITIES_F

Line 112: ldegree per_disabilities_f.degree%TYPE;

108: AND peffective_date BETWEEN nvl(pcr.date_start,START_OF_TIME)
109: AND nvl(pcr.date_end,END_OF_TIME);
110: --
111: lage NUMBER;
112: ldegree per_disabilities_f.degree%TYPE;
113: lspecial_care_flag per_disabilities_f.dis_information1%TYPE;
114: ldisablity_amt NUMBER;
115: lspl_care_amt NUMBER;
116: l_asc_age_deduction NUMBER;

Line 113: lspecial_care_flag per_disabilities_f.dis_information1%TYPE;

109: AND nvl(pcr.date_end,END_OF_TIME);
110: --
111: lage NUMBER;
112: ldegree per_disabilities_f.degree%TYPE;
113: lspecial_care_flag per_disabilities_f.dis_information1%TYPE;
114: ldisablity_amt NUMBER;
115: lspl_care_amt NUMBER;
116: l_asc_age_deduction NUMBER;
117: --

Line 475: FROM per_disabilities_f pdf

471: --
472: CURSOR c_disability_info IS
473: SELECT pdf.dis_information1
474: ,pdf.degree
475: FROM per_disabilities_f pdf
476: WHERE pdf.person_id = pperson_id
477: AND pdf.dis_information_category = 'ES'
478: AND peffective_date BETWEEN pdf.effective_start_date
479: AND pdf.effective_end_date;