DBA Data[Home] [Help]

APPS.BSC_BIS_LOCKS_PVT dependencies on BSC_SYS_PERIODICITIES_VL

Line 3041: l_Periodicity_Name BSC_SYS_PERIODICITIES_VL.NAME%TYPE;

3037:
3038: FUNCTION Get_Periodicity_Name (
3039: p_Periodicity_Id IN NUMBER
3040: ) RETURN VARCHAR2 IS
3041: l_Periodicity_Name BSC_SYS_PERIODICITIES_VL.NAME%TYPE;
3042: BEGIN
3043: SELECT P.NAME INTO l_Periodicity_Name
3044: FROM BSC_SYS_PERIODICITIES_VL P
3045: WHERE P.PERIODICITY_ID = p_Periodicity_Id;

Line 3044: FROM BSC_SYS_PERIODICITIES_VL P

3040: ) RETURN VARCHAR2 IS
3041: l_Periodicity_Name BSC_SYS_PERIODICITIES_VL.NAME%TYPE;
3042: BEGIN
3043: SELECT P.NAME INTO l_Periodicity_Name
3044: FROM BSC_SYS_PERIODICITIES_VL P
3045: WHERE P.PERIODICITY_ID = p_Periodicity_Id;
3046:
3047:
3048: RETURN l_Periodicity_Name;