APPS.JA_JAINSTCR_XMLP_PKG dependencies on JAI_CMN_ST_FORMS

Line 150: JAI_CMN_ST_FORMS

146: CURSOR C_FORM_NUMBER IS
147: SELECT
148: FORM_NUMBER
149: FROM
150: JAI_CMN_ST_FORMS
151: WHERE FORM_ID = CF_FORM_NUMBERFORMULA.FORM_ID;
152: V_FORM_NUMBER JAI_CMN_ST_FORMS.FORM_NUMBER%TYPE;
153: BEGIN
154: OPEN C_FORM_NUMBER;

Line 152: V_FORM_NUMBER JAI_CMN_ST_FORMS.FORM_NUMBER%TYPE;

148: FORM_NUMBER
149: FROM
150: JAI_CMN_ST_FORMS
151: WHERE FORM_ID = CF_FORM_NUMBERFORMULA.FORM_ID;
152: V_FORM_NUMBER JAI_CMN_ST_FORMS.FORM_NUMBER%TYPE;
153: BEGIN
154: OPEN C_FORM_NUMBER;
155: FETCH C_FORM_NUMBER
156: INTO V_FORM_NUMBER;

Line 169: JAI_CMN_ST_FORMS

165: CURSOR C_FORM_DATE IS
166: SELECT
167: FORM_DATE
168: FROM
169: JAI_CMN_ST_FORMS
170: WHERE FORM_ID = CF_FORM_DATEFORMULA.FORM_ID;
171: V_FORM_DATE JAI_CMN_ST_FORMS.FORM_DATE%TYPE;
172: BEGIN
173: OPEN C_FORM_DATE;

Line 171: V_FORM_DATE JAI_CMN_ST_FORMS.FORM_DATE%TYPE;

167: FORM_DATE
168: FROM
169: JAI_CMN_ST_FORMS
170: WHERE FORM_ID = CF_FORM_DATEFORMULA.FORM_ID;
171: V_FORM_DATE JAI_CMN_ST_FORMS.FORM_DATE%TYPE;
172: BEGIN
173: OPEN C_FORM_DATE;
174: FETCH C_FORM_DATE
175: INTO V_FORM_DATE;