APPS.IGC_CC_YEP_PROCESS_PKG dependencies on IGC_CC_DET_PF

Line 46: FROM IGC_CC_DET_PF B

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
48: ( B.CC_DET_PF_DATE >= p_yr_start_date AND B.CC_DET_PF_DATE <= p_yr_end_date) );
49:
50: CURSOR C16(p_cc_acct_line_id NUMBER) IS

Line 52: FROM IGC_CC_DET_PF B

48: ( B.CC_DET_PF_DATE >= p_yr_start_date AND B.CC_DET_PF_DATE <= p_yr_end_date) );
49:
50: CURSOR C16(p_cc_acct_line_id NUMBER) IS
51: SELECT *
52: FROM IGC_CC_DET_PF B
53: WHERE B.CC_ACCT_LINE_ID = p_cc_acct_line_id;
54:
55:
56:

Line 84: l_cc_det_pf_encmbrnc_date igc_cc_det_pf.cc_det_pf_encmbrnc_date%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;
88: l_EXCEPTION igc_cc_process_exceptions.exception_reason%TYPE := NULL;

Line 507: FROM igc_cc_det_pf_v

503: SELECT cc_det_pf_func_amt,
504: cc_det_pf_func_billed_amt
505: INTO l_func_amt,
506: l_func_billed_amt
507: FROM igc_cc_det_pf_v
508: WHERE cc_det_pf_line_id = V16.cc_det_pf_line_id;
509:
510: l_unbilled_amt := l_func_amt - l_func_billed_amt;
511:

Line 517: IGC_CC_DET_PF_HISTORY_PKG.Insert_Row(

513: AND V16.CC_DET_PF_DATE <= p_yr_end_date
514: AND l_unbilled_amt > 0
515: THEN
516:
517: IGC_CC_DET_PF_HISTORY_PKG.Insert_Row(
518: l_api_version,
519: l_init_msg_list,
520: l_commit,
521: l_validation_level,

Line 600: FROM IGC_CC_DET_PF D

596: END IF;
597:
598:
599: SELECT ROWID INTO l_DET_PF_LINE_ROWID
600: FROM IGC_CC_DET_PF D
601: WHERE D.CC_DET_PF_LINE_ID = V16.CC_DET_PF_LINE_ID
602: AND D.CC_ACCT_LINE_ID = V15.CC_ACCT_LINE_ID;
603:
604: IF ( (l_cc_state = 'PR') OR (l_cc_state = 'CL') )

Line 618: IGC_CC_DET_PF_PKG.Update_Row(

614:
615: END IF;
616:
617:
618: IGC_CC_DET_PF_PKG.Update_Row(
619: l_api_version,
620: l_init_msg_list,
621: l_commit,
622: 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 974: IGC_CC_DET_PF C

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 );
978: