APPS.JA_JAINARDR_XMLP_PKG dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 760: CURSOR GET_APP_COLUMN_NAME(CP_ID_FLEX_CODE IN FND_SEGMENT_ATTRIBUTE_VALUES.ID_FLEX_CODE%TYPE,CP_SEG_ATT_TYPE IN FND_SEGMENT_ATTRIBUTE_VALUES.SEGMENT_ATTRIBUTE_TYPE%TYPE) IS

756: CLOSE GET_LOCATION_NAME;
757: RETURN (V_ORG_NAME);
758: END CF_1FORMULA0040;
759: FUNCTION DESCRIPTIONFORMULA(ACCOUNT_ID IN NUMBER) RETURN CHAR IS
760: CURSOR GET_APP_COLUMN_NAME(CP_ID_FLEX_CODE IN FND_SEGMENT_ATTRIBUTE_VALUES.ID_FLEX_CODE%TYPE,CP_SEG_ATT_TYPE IN FND_SEGMENT_ATTRIBUTE_VALUES.SEGMENT_ATTRIBUTE_TYPE%TYPE) IS
761: SELECT
762: DISTINCT
763: APPLICATION_COLUMN_NAME
764: FROM

Line 765: FND_SEGMENT_ATTRIBUTE_VALUES

761: SELECT
762: DISTINCT
763: APPLICATION_COLUMN_NAME
764: FROM
765: FND_SEGMENT_ATTRIBUTE_VALUES
766: WHERE APPLICATION_ID = 101
767: AND ID_FLEX_CODE = CP_ID_FLEX_CODE
768: AND ID_FLEX_NUM = P_CHART_OF_ACCOUNTS_ID
769: AND SEGMENT_ATTRIBUTE_TYPE = CP_SEG_ATT_TYPE

Line 771: CURSOR FLEX_VAL_SET_ID(V_COLUMN_NAME IN VARCHAR2,CP_ID_FLEX_CODE IN FND_SEGMENT_ATTRIBUTE_VALUES.ID_FLEX_CODE%TYPE) IS

767: AND ID_FLEX_CODE = CP_ID_FLEX_CODE
768: AND ID_FLEX_NUM = P_CHART_OF_ACCOUNTS_ID
769: AND SEGMENT_ATTRIBUTE_TYPE = CP_SEG_ATT_TYPE
770: AND ATTRIBUTE_VALUE = 'Y';
771: CURSOR FLEX_VAL_SET_ID(V_COLUMN_NAME IN VARCHAR2,CP_ID_FLEX_CODE IN FND_SEGMENT_ATTRIBUTE_VALUES.ID_FLEX_CODE%TYPE) IS
772: SELECT
773: A.FLEX_VALUE_SET_ID
774: FROM
775: FND_ID_FLEX_SEGMENTS A