DBA Data[Home] [Help]

APPS.HR_JP_ID_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 490: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ELEMENT_TYPES_F%ROWTYPE

486: p_element_name IN VARCHAR2,
487: p_business_group_id IN NUMBER DEFAULT NULL,
488: p_legislation_code IN VARCHAR2 DEFAULT NULL,
489: p_effective_date IN DATE DEFAULT hr_api.g_sys,
490: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ELEMENT_TYPES_F%ROWTYPE
491: --------------------------------------------------------------------------------
492: IS
493: l_csr RefCsr;
494: l_rec PAY_ELEMENT_TYPES_F%ROWTYPE;

Line 494: l_rec PAY_ELEMENT_TYPES_F%ROWTYPE;

490: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ELEMENT_TYPES_F%ROWTYPE
491: --------------------------------------------------------------------------------
492: IS
493: l_csr RefCsr;
494: l_rec PAY_ELEMENT_TYPES_F%ROWTYPE;
495: BEGIN
496: l_csr := csr_with_bus_leg('PAY_ELEMENT_TYPES_F','ELEMENT_NAME','T',p_element_name,p_business_group_id,p_legislation_code,'DATETRACKED',p_effective_date);
497: fetch l_csr into l_rec;
498: if not csr_found_and_close(l_csr,p_error_when_not_exist) then

Line 496: l_csr := csr_with_bus_leg('PAY_ELEMENT_TYPES_F','ELEMENT_NAME','T',p_element_name,p_business_group_id,p_legislation_code,'DATETRACKED',p_effective_date);

492: IS
493: l_csr RefCsr;
494: l_rec PAY_ELEMENT_TYPES_F%ROWTYPE;
495: BEGIN
496: l_csr := csr_with_bus_leg('PAY_ELEMENT_TYPES_F','ELEMENT_NAME','T',p_element_name,p_business_group_id,p_legislation_code,'DATETRACKED',p_effective_date);
497: fetch l_csr into l_rec;
498: if not csr_found_and_close(l_csr,p_error_when_not_exist) then
499: l_rec := NULL;
500: end if;