DBA Data[Home] [Help]

APPS.HR_JP_ID_PKG dependencies on PAY_USER_TABLES

Line 610: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_USER_TABLES%ROWTYPE

606: FUNCTION user_table_rec(
607: p_user_table_name IN VARCHAR2,
608: p_business_group_id IN NUMBER DEFAULT NULL,
609: p_legislation_code IN VARCHAR2 DEFAULT NULL,
610: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_USER_TABLES%ROWTYPE
611: --------------------------------------------------------------------------------
612: IS
613: l_csr RefCsr;
614: l_rec PAY_USER_TABLES%ROWTYPE;

Line 614: l_rec PAY_USER_TABLES%ROWTYPE;

610: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_USER_TABLES%ROWTYPE
611: --------------------------------------------------------------------------------
612: IS
613: l_csr RefCsr;
614: l_rec PAY_USER_TABLES%ROWTYPE;
615: BEGIN
616: l_csr := csr_with_bus_leg('PAY_USER_TABLES','USER_TABLE_NAME','T',p_user_table_name,p_business_group_id,p_legislation_code);
617: fetch l_csr into l_rec;
618: if not csr_found_and_close(l_csr,p_error_when_not_exist) then

Line 616: l_csr := csr_with_bus_leg('PAY_USER_TABLES','USER_TABLE_NAME','T',p_user_table_name,p_business_group_id,p_legislation_code);

612: IS
613: l_csr RefCsr;
614: l_rec PAY_USER_TABLES%ROWTYPE;
615: BEGIN
616: l_csr := csr_with_bus_leg('PAY_USER_TABLES','USER_TABLE_NAME','T',p_user_table_name,p_business_group_id,p_legislation_code);
617: fetch l_csr into l_rec;
618: if not csr_found_and_close(l_csr,p_error_when_not_exist) then
619: l_rec := NULL;
620: end if;