DBA Data[Home] [Help]

APPS.PER_VIEWS_PKG dependencies on PER_PAY_BASES

Line 128: v_PAY_ANNUALIZATION_FACTOR PER_PAY_BASES.PAY_ANNUALIZATION_FACTOR%type;

124: v_frequency VARCHAR2(80);
125: v_adj_mid NUMBER;
126: --changes for bug no 5945278 starts here
127: v_PAY_BASIS_ID per_assignments_f.pay_basis_id%type;
128: v_PAY_ANNUALIZATION_FACTOR PER_PAY_BASES.PAY_ANNUALIZATION_FACTOR%type;
129: v_GRADE_ANNUALIZATION_FACTOR PER_PAY_BASES.GRADE_ANNUALIZATION_FACTOR%type;
130: v_proposed_salary number;
131: --changes for bug no 5945278 ends here
132: cursor grade_rate_values (l_assignment_id NUMBER,

Line 129: v_GRADE_ANNUALIZATION_FACTOR PER_PAY_BASES.GRADE_ANNUALIZATION_FACTOR%type;

125: v_adj_mid NUMBER;
126: --changes for bug no 5945278 starts here
127: v_PAY_BASIS_ID per_assignments_f.pay_basis_id%type;
128: v_PAY_ANNUALIZATION_FACTOR PER_PAY_BASES.PAY_ANNUALIZATION_FACTOR%type;
129: v_GRADE_ANNUALIZATION_FACTOR PER_PAY_BASES.GRADE_ANNUALIZATION_FACTOR%type;
130: v_proposed_salary number;
131: --changes for bug no 5945278 ends here
132: cursor grade_rate_values (l_assignment_id NUMBER,
133: l_grade_id NUMBER,

Line 160: select PAY_ANNUALIZATION_FACTOR,GRADE_ANNUALIZATION_FACTOR from PER_PAY_BASES

156: and gr.effective_end_date
157: order by gr.effective_start_date desc ;
158: --changes for bug no 5945278 starts here
159: Cursor ANNUALIZATION_FACTOR(l_PAY_BASIS_ID number) is
160: select PAY_ANNUALIZATION_FACTOR,GRADE_ANNUALIZATION_FACTOR from PER_PAY_BASES
161: where PAY_BASIS_ID = l_PAY_BASIS_ID;
162: --changes for bug no 5945278 ends here
163: ---------------------------------------------------------------------------
164: -- This function pro-rates a non-hourly salary based on the normal hours