APPS.IGC_CC_ACCT_LINES_PKG dependencies on IGC_CC_HEADERS

Line 141: l_version_num IGC_CC_HEADERS.CC_Version_Num%TYPE ;

137:
138: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
139: l_api_version CONSTANT NUMBER := 1.0;
140:
141: l_version_num IGC_CC_HEADERS.CC_Version_Num%TYPE ;
142:
143: l_Application_Id NUMBER;
144: l_MRC_Enabled VARCHAR2(1);
145: l_Conversion_Date DATE;

Line 160: FROM IGC_CC_HEADERS

156: WHERE CC_Acct_Line_Id = p_CC_Acct_Line_Id;
157:
158: CURSOR c_cc_version_num IS
159: SELECT CC_Version_Num
160: FROM IGC_CC_HEADERS
161: WHERE CC_Header_Id = p_CC_Header_Id;
162:
163: CURSOR c_igc_app_id IS
164: SELECT Application_Id

Line 172: FROM IGC_CC_HEADERS,

168: CURSOR c_cc_info IS
169: SELECT SET_OF_BOOKS_ID,
170: ORG_ID,
171: CONVERSION_DATE
172: FROM IGC_CC_HEADERS,
173: IGC_CC_ACCT_LINES
174: WHERE IGC_CC_HEADERS.CC_HEADER_ID = IGC_CC_ACCT_LINES.CC_HEADER_ID
175: AND IGC_CC_ACCT_LINES.CC_ACCT_LINE_ID = p_CC_Acct_Line_Id;
176:

Line 174: WHERE IGC_CC_HEADERS.CC_HEADER_ID = IGC_CC_ACCT_LINES.CC_HEADER_ID

170: ORG_ID,
171: CONVERSION_DATE
172: FROM IGC_CC_HEADERS,
173: IGC_CC_ACCT_LINES
174: WHERE IGC_CC_HEADERS.CC_HEADER_ID = IGC_CC_ACCT_LINES.CC_HEADER_ID
175: AND IGC_CC_ACCT_LINES.CC_ACCT_LINE_ID = p_CC_Acct_Line_Id;
176:
177: l_full_path VARCHAR2(255);
178:

Line 1133: FROM IGC_CC_HEADERS ICH,

1129:
1130: CURSOR c_acct_line_info IS
1131: SELECT ICH.set_of_books_id,
1132: ICH.org_id
1133: FROM IGC_CC_HEADERS ICH,
1134: IGC_CC_ACCT_LINES IAL
1135: WHERE ICH.CC_HEADER_ID = IAL.CC_HEADER_ID
1136: AND IAL.CC_ACCT_LINE_ID = p_CC_Acct_Line_Id;
1137:

Line 1473: l_version_num IGC_CC_HEADERS.CC_Version_Num%TYPE;

1469: l_Application_Id NUMBER;
1470: l_return_status VARCHAR2(1) ;
1471: l_msg_count NUMBER ;
1472: l_msg_data VARCHAR2(2000) ;
1473: l_version_num IGC_CC_HEADERS.CC_Version_Num%TYPE;
1474: l_acct_row_id Varchar2(18);
1475: l_pf_row_id Varchar2(18);
1476: l_action_flag VARCHAR2(1) := 'D';
1477: l_Conversion_Date DATE;

Line 1491: FROM IGC_CC_HEADERS ICH,

1487: WHERE Rowid = p_Rowid;
1488:
1489: CURSOR c_cc_version_num IS
1490: SELECT ICH.CC_Version_Num
1491: FROM IGC_CC_HEADERS ICH,
1492: IGC_CC_ACCT_LINES IAL
1493: WHERE ICH.CC_Header_Id = IAL.CC_Header_Id
1494: AND IAL.Rowid = p_Rowid;
1495:

Line 1507: FROM IGC_CC_HEADERS ICH,

1503: CURSOR c_cc_info IS
1504: SELECT ICH.SET_OF_BOOKS_ID,
1505: ICH.ORG_ID,
1506: ICH.CONVERSION_DATE
1507: FROM IGC_CC_HEADERS ICH,
1508: IGC_CC_ACCT_LINES CAL
1509: WHERE ICH.CC_HEADER_ID = CAL.CC_HEADER_ID
1510: AND CAL.CC_ACCT_LINE_ID = Recinfo.cc_acct_line_id;
1511: