DBA Data[Home] [Help]

APPS.JA_JAINPLA_XMLP_PKG dependencies on JAI_CMN_FIN_YEARS

Line 1082: CURSOR CUR_FIN_YEAR(CP_ORG_ID IN JAI_CMN_FIN_YEARS.ORGANIZATION_ID%TYPE,CP_FROM_DATE IN DATE) IS

1078: PROCEDURE OPENING_BALANCE IS
1079: BASIC_BAL NUMBER;
1080: ADDITIONAL_BAL NUMBER;
1081: OTHER_BAL NUMBER;
1082: CURSOR CUR_FIN_YEAR(CP_ORG_ID IN JAI_CMN_FIN_YEARS.ORGANIZATION_ID%TYPE,CP_FROM_DATE IN DATE) IS
1083: SELECT
1084: JCFY.FIN_YEAR
1085: FROM
1086: JAI_CMN_FIN_YEARS JCFY

Line 1086: JAI_CMN_FIN_YEARS JCFY

1082: CURSOR CUR_FIN_YEAR(CP_ORG_ID IN JAI_CMN_FIN_YEARS.ORGANIZATION_ID%TYPE,CP_FROM_DATE IN DATE) IS
1083: SELECT
1084: JCFY.FIN_YEAR
1085: FROM
1086: JAI_CMN_FIN_YEARS JCFY
1087: WHERE JCFY.ORGANIZATION_ID = CP_ORG_ID
1088: AND CP_FROM_DATE BETWEEN JCFY.FIN_YEAR_START_DATE
1089: AND JCFY.FIN_YEAR_END_DATE;
1090: CURSOR CUR_REG_ID(CP_TAX_TYPE IN VARCHAR2,CP_FIN_YEAR IN NUMBER) IS