APPS.IGC_CC_COMP_AMT_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 15

	SELECT  cc_acct_line_num,   cc_header_id
	INTO    l_cc_acct_line_num, l_cc_header_id
	FROM    igc_cc_acct_lines
	WHERE   cc_acct_line_id     = p_cc_acct_line_id;

Line: 20

	SELECT  cc_num, org_id, cc_type
        INTO    l_cc_num, l_org_id, l_cc_type
	FROM    igc_cc_headers
	WHERE   cc_header_id = l_cc_header_id;

Line: 29

			SELECT NVL(SUM(DECODE(apid.base_amount,NULL,apid.amount,apid.base_amount)),0)
				INTO l_func_billed_amount
			FROM
				ap_invoice_distributions_all apid,
               			po_distributions_all pod,
	        		po_line_locations_all pll,
	       	 		po_lines_all pol,
               		 	po_headers_all poh
			WHERE
				apid.po_distribution_id    = pod.po_distribution_id AND
				apid.LINE_TYPE_LOOKUP_CODE = 'ITEM' AND
				poh.segment1               = l_cc_num AND
				poh.type_lookup_code       = 'STANDARD' AND
				poh.org_id                 = l_org_id AND
				pol.po_header_id           = poh.po_header_id AND
				pol.line_num               = l_cc_acct_line_num AND
				pll.po_line_id             = pol.po_line_id AND
				pll.po_header_id           = pol.po_header_id AND
				pod.po_header_id           = pll.po_header_id AND
				pod.po_line_id             = pll.po_line_id AND
				pod.line_location_id       = pll.line_location_id ;

Line: 62

			SELECT NVL(SUM(NVL(cc_acct_func_billed_amt,0)),0)
			INTO l_func_billed_amount
			FROM igc_cc_acct_lines
			WHERE parent_acct_line_id = p_cc_acct_line_id;

Line: 67

			SELECT NVL(SUM(NVL(IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_FUNC_BILLED_AMT( ccal.cc_acct_line_id),0)),0)
			INTO l_func_billed_amount
			FROM igc_cc_acct_lines ccal
			WHERE ccal.parent_acct_line_id = p_cc_acct_line_id;

Line: 95

	SELECT  cc_acct_line_num,   cc_header_id
	INTO    l_cc_acct_line_num, l_cc_header_id
	FROM    igc_cc_acct_lines
	WHERE   cc_acct_line_id     = p_cc_acct_line_id;

Line: 100

	SELECT  cc_num, org_id, cc_type
        INTO    l_cc_num, l_org_id, l_cc_type
	FROM    igc_cc_headers
	WHERE   cc_header_id = l_cc_header_id;

Line: 110

			SELECT NVL(SUM(DECODE(apid.base_amount,NULL,apid.amount,apid.base_amount)),0)
				INTO l_func_billed_amount
			FROM
				ap_invoice_distributions_all apid,
               			po_distributions_all pod,
	        		po_line_locations_all pll,
	       	 		po_lines_all pol,
               		 	po_headers_all poh
			WHERE
				apid.po_distribution_id    = pod.po_distribution_id AND
				apid.LINE_TYPE_LOOKUP_CODE = 'ITEM' AND
				poh.segment1               = l_cc_num AND
				poh.type_lookup_code       = 'STANDARD' AND
				poh.org_id                 = l_org_id AND
				pol.po_header_id           = poh.po_header_id AND
				pol.line_num               = l_cc_acct_line_num AND
				pll.po_line_id             = pol.po_line_id AND
				pll.po_header_id           = pol.po_header_id AND
				pod.po_header_id           = pll.po_header_id AND
				pod.po_line_id             = pll.po_line_id AND
				pod.line_location_id       = pll.line_location_id AND
				pod.distribution_num       = p_cc_det_pf_line_num;

Line: 140

			SELECT NVL(SUM(NVL(cc_det_pf_func_billed_amt,0)),0)
			INTO l_func_billed_amount
			FROM igc_cc_det_pf_v
			WHERE parent_det_pf_line_id = p_cc_det_pf_line_id;

Line: 171

	SELECT  cc_acct_line_num,   cc_header_id
	INTO    l_cc_acct_line_num, l_cc_header_id
	FROM    igc_cc_acct_lines
	WHERE   cc_acct_line_id     = p_cc_acct_line_id;

Line: 176

	SELECT  cc_num, org_id, cc_type, set_of_books_id, currency_code
        INTO    l_cc_num, l_org_id, l_cc_type, l_sob_id, l_currency_code
	FROM    igc_cc_headers
	WHERE   cc_header_id = l_cc_header_id;

Line: 181

	SELECT currency_code
        INTO  l_func_currency_code
	FROM gl_sets_of_books
        WHERE set_of_books_id = l_sob_id;

Line: 191

			SELECT  NVL(pod.amount_billed,0)
			INTO    l_billed_amount
			FROM
				po_headers_all poh,
				po_lines_all   pol,
				po_line_locations_all pll,
				po_distributions_all pod
			WHERE
				poh.segment1         = l_cc_num AND
				poh.type_lookup_code = 'STANDARD' AND
				poh.org_id           = l_org_id AND
				pol.po_header_id     = poh.po_header_id AND
				pol.line_num         = l_cc_acct_line_num AND
				pll.po_line_id       = pol.po_line_id AND
				pll.po_header_id     = pol.po_header_id AND
				pod.po_header_id     = pll.po_header_id AND
				pod.po_line_id       = pll.po_line_id AND
				pod.line_location_id = pll.line_location_id AND
				pod.distribution_num = p_cc_det_pf_line_num;

Line: 226

				SELECT NVL(SUM(NVL(cc_det_pf_billed_amt,0)),0)
				INTO l_billed_amount
				FROM igc_cc_det_pf_v
				WHERE parent_det_pf_line_id = p_cc_det_pf_line_id;

Line: 242

			 SELECT NVL(SUM(NVL(COMPUTE_PF_BILL_AMT_CURR(det.cc_det_pf_line_id,
                	 det.cc_det_pf_line_num,det.cc_acct_line_id),0)),0)
                         INTO l_billed_amount
                	 FROM igc_cc_det_pf det
                 	 where parent_det_pf_line_id=p_cc_det_pf_line_id;

Line: 276

	SELECT  cc_acct_line_num,   cc_header_id
	INTO    l_cc_acct_line_num, l_cc_header_id
	FROM    igc_cc_acct_lines
	WHERE   cc_acct_line_id     = p_cc_acct_line_id;

Line: 281

	SELECT  cc_num, org_id, cc_type, set_of_books_id, currency_code
        INTO    l_cc_num, l_org_id, l_cc_type, l_sob_id, l_currency_code
	FROM    igc_cc_headers
	WHERE   cc_header_id = l_cc_header_id;

Line: 286

	SELECT currency_code
        INTO  l_func_currency_code
	FROM gl_sets_of_books
        WHERE set_of_books_id = l_sob_id;

Line: 296

			SELECT NVL(SUM(NVL(pod.amount_billed,0)),0)
			INTO l_billed_amount
			FROM
				po_headers_all poh,
				po_lines_all pol,
				po_line_locations_all pll,
				po_distributions_all pod
			WHERE
				poh.segment1 = l_cc_num AND
				poh.type_lookup_code = 'STANDARD' AND
				poh.org_id  = l_org_id AND
				pol.po_header_id = poh.po_header_id AND
				pol.line_num = l_cc_acct_line_num AND
				pll.po_line_id = pol.po_line_id AND
				pll.po_header_id = pol.po_header_id AND
				pod.po_header_id = pll.po_header_id AND
				pod.po_line_id = pll.po_line_id AND
				pod.line_location_id = pll.line_location_id ;

Line: 333

				SELECT NVL(SUM(NVL(cc_acct_billed_amt,0)),0)
				INTO l_billed_amount
				FROM igc_cc_acct_lines_v
				WHERE parent_acct_line_id = p_cc_acct_line_id;

Line: 338

				SELECT NVL(SUM(NVL(IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_BILLED_AMT( ccal.cc_acct_line_id),0)),0)
				INTO l_billed_amount
				FROM igc_cc_acct_lines ccal
				WHERE ccal.parent_acct_line_id = p_cc_acct_line_id;

Line: 355

				SELECT NVL(SUM(NVL(cc_acct_func_billed_amt,0)),0)
				INTO l_billed_amount
				FROM igc_cc_acct_lines_v
				WHERE parent_acct_line_id = p_cc_acct_line_id;

Line: 360

				SELECT NVL(SUM(NVL(IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_BILLED_AMT_CURR( ccal.cc_acct_line_id),0)),0)
				INTO l_billed_amount
				FROM igc_cc_acct_lines ccal
				WHERE ccal.parent_acct_line_id = p_cc_acct_line_id;

Line: 384

		SELECT cc.conversion_rate
		INTO l_cc_conversion_rate
		FROM igc_cc_headers cc
		WHERE cc.cc_header_id = p_cc_header_id;

Line: 412

	SELECT  cc_acct_line_num,   cc_header_id
	INTO    l_cc_acct_line_num, l_cc_header_id
	FROM    igc_cc_acct_lines
	WHERE   cc_acct_line_id     = p_cc_acct_line_id;

Line: 417

	SELECT  cc_num, org_id, cc_type
        INTO    l_cc_num, l_org_id, l_cc_type
	FROM    igc_cc_headers
	WHERE   cc_header_id = l_cc_header_id;

Line: 427

			SELECT NVL(SUM(DECODE(apid.base_amount,NULL,apid.amount,apid.base_amount)),0)
				INTO l_func_billed_amount
			FROM
				ap_invoice_distributions_all apid,
               			po_distributions_all pod,
	        		po_line_locations_all pll,
	       	 		po_lines_all pol,
               		 	po_headers_all poh
			WHERE
				apid.po_distribution_id    = pod.po_distribution_id AND
				poh.segment1               = l_cc_num AND
				poh.type_lookup_code       = 'STANDARD' AND
				poh.org_id                 = l_org_id AND
				pol.po_header_id           = poh.po_header_id AND
				pol.line_num               = l_cc_acct_line_num AND
				pll.po_line_id             = pol.po_line_id AND
				pll.po_header_id           = pol.po_header_id AND
				pod.po_header_id           = pll.po_header_id AND
				pod.po_line_id             = pll.po_line_id AND
				pod.line_location_id       = pll.line_location_id AND
				pod.distribution_num       = p_cc_det_pf_line_num;

Line: 456

			SELECT NVL(SUM(NVL(cc_det_pf_func_billed_amt,0)),0)
			INTO l_func_billed_amount
			FROM igc_cc_det_pf_v
			WHERE parent_det_pf_line_id = p_cc_det_pf_line_id;

Line: 482

	SELECT  cc_acct_line_num,   cc_header_id
	INTO    l_cc_acct_line_num, l_cc_header_id
	FROM    igc_cc_acct_lines
	WHERE   cc_acct_line_id     = p_cc_acct_line_id;

Line: 487

	SELECT  cc_num, org_id, cc_type
        INTO    l_cc_num, l_org_id, l_cc_type
	FROM    igc_cc_headers
	WHERE   cc_header_id = l_cc_header_id;

Line: 496

			SELECT NVL(SUM(DECODE(apid.base_amount,NULL,apid.amount,apid.base_amount)),0)
				INTO l_func_billed_amount
			FROM
				ap_invoice_distributions_all apid,
               			po_distributions_all pod,
	        		po_line_locations_all pll,
	       	 		po_lines_all pol,
               		 	po_headers_all poh
			WHERE
				apid.po_distribution_id    = pod.po_distribution_id AND
				poh.segment1               = l_cc_num AND
				poh.type_lookup_code       = 'STANDARD' AND
				poh.org_id                 = l_org_id AND
				pol.po_header_id           = poh.po_header_id AND
				pol.line_num               = l_cc_acct_line_num AND
				pll.po_line_id             = pol.po_line_id AND
				pll.po_header_id           = pol.po_header_id AND
				pod.po_header_id           = pll.po_header_id AND
				pod.po_line_id             = pll.po_line_id AND
				pod.line_location_id       = pll.line_location_id ;

Line: 528

			SELECT NVL(SUM(NVL(cc_acct_func_billed_amt,0)),0)
			INTO l_func_billed_amount
			FROM igc_cc_acct_lines
			WHERE parent_acct_line_id = p_cc_acct_line_id;

Line: 533

			SELECT NVL(SUM(NVL(IGC_CC_COMP_AMT_PKG.COMPUTE_ACCT_FUNC_BILLED_AMT( ccal.cc_acct_line_id),0)),0)
			INTO l_func_billed_amount
			FROM igc_cc_acct_lines ccal
			WHERE ccal.parent_acct_line_id = p_cc_acct_line_id;