DBA Data[Home] [Help]

APPS.PER_RI_CRP_DEFAULT_SETTINGS dependencies on PER_PAY_BASES

Line 272: l_name PER_PAY_BASES.NAME%TYPE := p_name;

268:
269: IS
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;

Line 273: l_pay_basis_name PER_PAY_BASES.PAY_BASIS%TYPE := p_pay_basis_name;

269: IS
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;

Line 275: l_pay_annualization_factor PER_PAY_BASES.PAY_ANNUALIZATION_FACTOR%TYPE := p_pay_annualization_factor;

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:
279: -- OUT Variables

Line 276: l_grade_annualization_factor PER_PAY_BASES.GRADE_ANNUALIZATION_FACTOR%TYPE := p_grade_annualization_factor;

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:
279: -- OUT Variables
280: l_pay_basis_id PER_PAY_BASES.PAY_BASIS_ID%TYPE := null;

Line 280: l_pay_basis_id PER_PAY_BASES.PAY_BASIS_ID%TYPE := null;

276: l_grade_annualization_factor PER_PAY_BASES.GRADE_ANNUALIZATION_FACTOR%TYPE := p_grade_annualization_factor;
277: l_verify_salary_basis NUMBER;
278:
279: -- OUT Variables
280: l_pay_basis_id PER_PAY_BASES.PAY_BASIS_ID%TYPE := null;
281: l_object_version_number PAY_ELEMENT_LINKS_F.OBJECT_VERSION_NUMBER%TYPE := null;
282:
283:
284: -- Declare a cursor to capture input value id

Line 312: FROM PER_PAY_BASES

308: CLOSE csr_rate_id;
309:
310:
311: SELECT COUNT(*) INTO l_verify_salary_basis
312: FROM PER_PAY_BASES
313: WHERE name = p_name
314: AND business_group_id = p_bg_id;
315:
316: IF (l_verify_salary_basis <>0) THEN