APPS.IGC_CC_DET_PF_PKG dependencies on IGC_CC_HEADERS

Line 128: l_version_num IGC_CC_HEADERS.CC_Version_Num%TYPE;

124: ) IS
125:
126: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
127: l_api_version CONSTANT NUMBER := 1.0;
128: l_version_num IGC_CC_HEADERS.CC_Version_Num%TYPE;
129: l_Application_Id NUMBER;
130: l_MRC_Enabled VARCHAR2(1);
131: l_Conversion_Date DATE;
132: l_Set_Of_Books_Id NUMBER;

Line 146: from IGC_CC_HEADERS ICH,

142: WHERE CC_Det_PF_Line_Id = p_CC_Det_PF_Line_Id;
143:
144: CURSOR c_cc_version_num IS
145: SELECT CC_Version_Num
146: from IGC_CC_HEADERS ICH,
147: IGC_CC_ACCT_LINES IAL
148: WHERE ICH.CC_HEADER_ID = IAL.CC_HEADER_ID
149: and IAL.CC_ACCT_LINE_ID = p_cc_acct_line_id;
150:

Line 159: FROM IGC_CC_HEADERS ICH,

155:
156: CURSOR c_det_pf_info IS
157: SELECT SET_OF_BOOKS_ID,
158: ORG_ID,CONVERSION_DATE
159: FROM IGC_CC_HEADERS ICH,
160: IGC_CC_ACCT_LINES IAL,
161: IGC_CC_DET_PF IDP
162: WHERE ICH.CC_HEADER_ID = IAL.CC_HEADER_ID
163: AND IDP.CC_ACCT_LINE_ID = IAL.CC_ACCT_LINE_ID

Line 998: FROM IGC_CC_HEADERS ICH,

994:
995: CURSOR c_det_pf_info IS
996: SELECT ICH.SET_OF_BOOKS_ID,
997: ICH.ORG_ID
998: FROM IGC_CC_HEADERS ICH,
999: IGC_CC_ACCT_LINES IAL,
1000: IGC_CC_DET_PF IDP
1001: WHERE ICH.CC_HEADER_ID = IAL.CC_HEADER_ID
1002: AND IDP.CC_ACCT_LINE_ID = IAL.CC_ACCT_LINE_ID

Line 1314: l_version_num IGC_CC_HEADERS.CC_Version_Num%TYPE;

1310: l_api_version CONSTANT NUMBER := 1.0;
1311: l_return_status VARCHAR2(1);
1312: l_msg_count NUMBER;
1313: l_msg_data VARCHAR2(2000);
1314: l_version_num IGC_CC_HEADERS.CC_Version_Num%TYPE;
1315: l_action_flag VARCHAR2(1) := 'D';
1316: l_det_pf_row_id VarChar2(18);
1317: l_Application_Id NUMBER;
1318: l_Conversion_Date DATE;

Line 1332: FROM IGC_CC_HEADERS ICH,

1328: WHERE Rowid = p_Rowid;
1329:
1330: CURSOR c_cc_version_num IS
1331: SELECT CC_Version_Num
1332: FROM IGC_CC_HEADERS ICH,
1333: IGC_CC_ACCT_LINES IAL,
1334: IGC_CC_DET_PF IDP
1335: WHERE ICH.CC_HEADER_ID = IAL.CC_HEADER_ID
1336: AND IAL.CC_ACCT_LINE_ID = IDP.CC_ACCT_LINE_ID

Line 1350: FROM IGC_CC_HEADERS ICH,

1346: CURSOR c_cc_info IS
1347: SELECT ICH.SET_OF_BOOKS_ID,
1348: ICH.ORG_ID,
1349: ICH.CONVERSION_DATE
1350: FROM IGC_CC_HEADERS ICH,
1351: IGC_CC_ACCT_LINES CAL,
1352: IGC_CC_DET_PF DPF
1353: WHERE ICH.CC_HEADER_ID = CAL.CC_HEADER_ID
1354: AND CAL.CC_ACCT_LINE_ID = DPF.CC_ACCT_LINE_ID