APPS.PER_RI_CRP_DEFAULT_SETTINGS dependencies on PAY_RATES

Line 274: l_rate_id PAY_RATES.RATE_ID%TYPE;

270: -- IN variables
271: l_input_value_id PAY_INPUT_VALUES_F.INPUT_VALUE_ID%TYPE;
272: l_name PER_PAY_BASES.NAME%TYPE := p_name;
273: l_pay_basis_name PER_PAY_BASES.PAY_BASIS%TYPE := p_pay_basis_name;
274: l_rate_id PAY_RATES.RATE_ID%TYPE;
275: l_pay_annualization_factor PER_PAY_BASES.PAY_ANNUALIZATION_FACTOR%TYPE := p_pay_annualization_factor;
276: l_grade_annualization_factor PER_PAY_BASES.GRADE_ANNUALIZATION_FACTOR%TYPE := p_grade_annualization_factor;
277: l_verify_salary_basis NUMBER;
278:

Line 296: FROM PAY_RATES

292:
293: -- Declare a cursor to capture rate basis id
294: CURSOR csr_rate_id IS
295: SELECT rate_id
296: FROM PAY_RATES
297: WHERE name = p_rate_name
298: and business_group_id = p_bg_id;
299:
300: BEGIN