APPS.IGC_CC_YEP_PROCESS_PKG dependencies on IGC_CC_ACCT_LINES

Line 43: FROM IGC_CC_ACCT_LINES A

39: WHERE IGC_CC_HEADERS.CC_HEADER_ID = p_CC_HEADER_ID;
40:
41: CURSOR C15(p_cc_header_id NUMBER, p_yr_start_date DATE, p_yr_end_date DATE) IS
42: SELECT *
43: FROM IGC_CC_ACCT_LINES A
44: WHERE A.CC_HEADER_ID = p_cc_header_id AND
45: EXISTS (SELECT 'X'
46: FROM IGC_CC_DET_PF B
47: WHERE B.CC_ACCT_LINE_ID = A.CC_ACCT_LINE_ID AND

Line 83: l_cc_acct_encmbrnc_date igc_cc_acct_lines.cc_acct_encmbrnc_date%TYPE;

79: l_application_id fnd_application.application_id%TYPE;
80: l_APPROVAL_STATUS IGC_CC_HEADERS.CC_APPRVL_STATUS%TYPE;
81: l_PROVISIONAL_COUNTER NUMBER;
82: l_CC_ACCT_DATE DATE;
83: l_cc_acct_encmbrnc_date igc_cc_acct_lines.cc_acct_encmbrnc_date%TYPE;
84: l_cc_det_pf_encmbrnc_date igc_cc_det_pf.cc_det_pf_encmbrnc_date%TYPE;
85: l_Last_Updated_By NUMBER := FND_GLOBAL.USER_ID;
86: l_Last_Update_Login NUMBER := FND_GLOBAL.LOGIN_ID;
87: l_Created_By NUMBER := FND_GLOBAL.USER_ID;

Line 379: FROM IGC_CC_ACCT_LINES B

375: END IF;
376:
377:
378: SELECT ROWID INTO l_ACCT_ROWID
379: FROM IGC_CC_ACCT_LINES B
380: WHERE B.CC_HEADER_ID = V14.CC_HEADER_ID
381: AND B.CC_ACCT_LINE_ID = V15.CC_ACCT_LINE_ID;
382:
383: IF ( ( l_cc_state = 'PR' OR l_cc_state = 'CL')

Line 397: IGC_CC_ACCT_LINES_PKG.Update_Row(

393: l_cc_acct_encmbrnc_date := v15.cc_acct_encmbrnc_date;
394:
395: END IF;
396:
397: IGC_CC_ACCT_LINES_PKG.Update_Row(
398: l_api_version ,
399: l_init_msg_list,
400: l_commit,
401: l_validation_level,

Line 946: -- FROM IGC_CC_HEADERS, IGC_CC_ACCT_LINES, IGC_CC_DET_PF

942: -- FROM IGC_CC_HEADERS
943: -- WHERE CC_HEADER_ID IN
944: -- (
945: -- SELECT IGC_CC_HEADERS.CC_HEADER_ID
946: -- FROM IGC_CC_HEADERS, IGC_CC_ACCT_LINES, IGC_CC_DET_PF
947: -- WHERE IGC_CC_DET_PF. CC_ACCT_LINE_ID = IGC_CC_ACCT_LINES. CC_ACCT_LINE_ID
948: -- AND IGC_CC_ACCT_LINES.CC_HEADER_ID = IGC_CC_HEADERS.CC_HEADER_ID
949: -- AND IGC_CC_HEADERS.SET_OF_BOOKS_ID = c_SOB_ID
950: -- AND IGC_CC_HEADERS.ORG_ID = c_ORG_ID

Line 947: -- WHERE IGC_CC_DET_PF. CC_ACCT_LINE_ID = IGC_CC_ACCT_LINES. CC_ACCT_LINE_ID

943: -- WHERE CC_HEADER_ID IN
944: -- (
945: -- SELECT IGC_CC_HEADERS.CC_HEADER_ID
946: -- FROM IGC_CC_HEADERS, IGC_CC_ACCT_LINES, IGC_CC_DET_PF
947: -- WHERE IGC_CC_DET_PF. CC_ACCT_LINE_ID = IGC_CC_ACCT_LINES. CC_ACCT_LINE_ID
948: -- AND IGC_CC_ACCT_LINES.CC_HEADER_ID = IGC_CC_HEADERS.CC_HEADER_ID
949: -- AND IGC_CC_HEADERS.SET_OF_BOOKS_ID = c_SOB_ID
950: -- AND IGC_CC_HEADERS.ORG_ID = c_ORG_ID
951: -- AND CC_DET_PF_DATE BETWEEN START_DATE AND END_DATE )

Line 948: -- AND IGC_CC_ACCT_LINES.CC_HEADER_ID = IGC_CC_HEADERS.CC_HEADER_ID

944: -- (
945: -- SELECT IGC_CC_HEADERS.CC_HEADER_ID
946: -- FROM IGC_CC_HEADERS, IGC_CC_ACCT_LINES, IGC_CC_DET_PF
947: -- WHERE IGC_CC_DET_PF. CC_ACCT_LINE_ID = IGC_CC_ACCT_LINES. CC_ACCT_LINE_ID
948: -- AND IGC_CC_ACCT_LINES.CC_HEADER_ID = IGC_CC_HEADERS.CC_HEADER_ID
949: -- AND IGC_CC_HEADERS.SET_OF_BOOKS_ID = c_SOB_ID
950: -- AND IGC_CC_HEADERS.ORG_ID = c_ORG_ID
951: -- AND CC_DET_PF_DATE BETWEEN START_DATE AND END_DATE )
952: --

Line 973: FROM IGC_CC_ACCT_LINES B,

969: AND A.ORG_ID = c_ORG_ID
970: AND EXISTS
971: (
972: SELECT 'X'
973: FROM IGC_CC_ACCT_LINES B,
974: IGC_CC_DET_PF C
975: WHERE B.CC_ACCT_LINE_ID = C.CC_ACCT_LINE_ID
976: AND B.CC_HEADER_ID = A.CC_HEADER_ID
977: AND C.CC_DET_PF_DATE BETWEEN START_DATE AND END_DATE );