APPS.FUN_BAL_UTILS_GRP SQL Statements

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

Line: 12

   SELECT  vals.legal_entity_id
   FROM    gl_ledger_le_bsv_specific_v vals
   WHERE   vals.segment_value     = p_bsv
   AND     vals.ledger_id         = p_ledger_id
   AND    (TRUNC(p_gl_date) BETWEEN TRUNC(NVL(vals.start_date, p_gl_date)) AND
                                 TRUNC(NVL(vals.end_date, p_gl_date)));

Line: 22

  SELECT fun_bal_pkg.get_segment_index(ledgers.chart_of_accounts_id,
                                       p_segment_type),
         ledgers.chart_of_accounts_id
  FROM gl_ledgers ledgers
  WHERE ledgers.ledger_id = p_ledger_id;

Line: 350

SELECT  NVL( (SELECT ccid
      FROM fun_inter_accounts accts
      WHERE accts.ledger_id   = p_ledger_id
      AND   accts.from_le_id  = p_from_le_id
      AND   accts.to_le_id    = p_to_le_id
      AND   accts.trans_bsv   = p_from_bsv
      AND   accts.tp_bsv      = p_to_bsv
      AND   accts.type        = p_acct_type
      AND   accts.default_flag = 'Y'
      AND   (TRUNC(p_gl_date) BETWEEN TRUNC(NVL(accts.start_date, p_gl_date))
                                    AND TRUNC(NVL(accts.end_date, p_gl_date)))),
      NVL((SELECT ccid
      FROM fun_inter_accounts accts
      WHERE accts.ledger_id   = p_ledger_id
      AND   accts.from_le_id  = p_from_le_id
      AND   accts.to_le_id    = p_to_le_id
      AND   accts.trans_bsv   = p_from_bsv
      AND   accts.tp_bsv      = 'OTHER1234567890123456789012345'
      AND   accts.type        = p_acct_type
      AND   accts.default_flag = 'Y'
      AND   (TRUNC(p_gl_date) BETWEEN TRUNC(NVL(accts.start_date, p_gl_date))
                                    AND TRUNC(NVL(accts.end_date, p_gl_date)))),
      NVL((SELECT ccid
      FROM fun_inter_accounts accts
      WHERE accts.ledger_id   = p_ledger_id
      AND   accts.from_le_id  = p_from_le_id
      AND   accts.to_le_id    = p_to_le_id
      AND   accts.trans_bsv   = 'OTHER1234567890123456789012345'
      AND   accts.tp_bsv      = p_to_bsv
      AND   accts.type        = p_acct_type
      AND   accts.default_flag = 'Y'
      AND   (TRUNC(p_gl_date) BETWEEN TRUNC(NVL(accts.start_date, p_gl_date))
                              AND TRUNC(NVL(accts.end_date, p_gl_date)))),
      NVL((SELECT ccid
      FROM fun_inter_accounts accts
      WHERE accts.ledger_id   = p_ledger_id
      AND   accts.from_le_id  = p_from_le_id
      AND   accts.to_le_id    = p_to_le_id
      AND   accts.trans_bsv   = 'OTHER1234567890123456789012345'
      AND   accts.tp_bsv      = 'OTHER1234567890123456789012345'
      AND   accts.type        = p_acct_type
      AND   accts.default_flag = 'Y'
      AND   (TRUNC(p_gl_date) BETWEEN TRUNC(NVL(accts.start_date, p_gl_date))
                              AND TRUNC(NVL(accts.end_date, p_gl_date)))),
     NVL((SELECT ccid
      FROM fun_inter_accounts accts
      WHERE accts.ledger_id   = p_ledger_id
      AND   accts.from_le_id  = p_from_le_id
      AND   accts.to_le_id    = -99
      AND   accts.trans_bsv   = p_from_bsv
      AND   accts.tp_bsv      = 'OTHER1234567890123456789012345'
      AND   accts.type        = p_acct_type
      AND   accts.default_flag = 'Y'
      AND   (TRUNC(p_gl_date) BETWEEN TRUNC(NVL(accts.start_date, p_gl_date))
                              AND TRUNC(NVL(accts.end_date, p_gl_date)))),
      (SELECT ccid
      FROM fun_inter_accounts accts
      WHERE accts.ledger_id   = p_ledger_id
      AND   accts.from_le_id  = p_from_le_id
      AND   accts.to_le_id    = -99
      AND   accts.trans_bsv   = 'OTHER1234567890123456789012345'
      AND   accts.tp_bsv      = 'OTHER1234567890123456789012345'
      AND   accts.type        = p_acct_type
      AND   accts.default_flag = 'Y'
      AND   (TRUNC(p_gl_date) BETWEEN TRUNC(NVL(accts.start_date, p_gl_date))
                              AND TRUNC(NVL(accts.end_date, p_gl_date))))))))) ccid
   From Dual;

Line: 424

SELECT  NVL((SELECT opts.template_id
             FROM  fun_balance_options opts
             WHERE opts.ledger_id        = p_ledger_id
             AND   Nvl(opts.le_id,-99)   = Nvl(p_le_id,-99)
             AND   opts.je_source_name   = p_source_name
             AND   opts.je_category_name = p_category_name
             AND   opts.status_flag      = 'Y'),
      NVL((SELECT opts.template_id
             FROM  fun_balance_options opts
             WHERE opts.ledger_id        = p_ledger_id
             AND   Nvl(opts.le_id,-99)   = Nvl(p_le_id,-99)
             AND   opts.je_source_name   = p_source_name
             AND   opts.je_category_name = 'Other'
             AND   opts.status_flag      = 'Y'),
      NVL((SELECT opts.template_id
             FROM  fun_balance_options opts
             WHERE opts.ledger_id        = p_ledger_id
             AND   Nvl(opts.le_id,-99)   = Nvl(p_le_id,-99)
             AND   opts.je_source_name   = 'Other'
             AND   opts.je_category_name = p_category_name
             AND   opts.status_flag      = 'Y'),
      (SELECT opts.template_id
             FROM  fun_balance_options opts
             WHERE opts.ledger_id        = p_ledger_id
             AND   Nvl(opts.le_id,-99)   = Nvl(p_le_id,-99)
             AND   opts.je_source_name   = 'Other'
             AND   opts.je_category_name = 'Other'
             AND   opts.status_flag      = 'Y')))) template_id
  From Dual where fun_trx_pvt.get_inter_intra()='Y';

Line: 457

SELECT DECODE (p_acct_type, 'D', accts.dr_ccid, 'C', cr_ccid) ccid
             FROM  fun_balance_accounts accts
             WHERE accts.template_id     = p_template_id
             AND   accts.dr_bsv          = 'OTHER1234567890123456789012345'
             AND   accts.cr_bsv          = 'OTHER1234567890123456789012345' ;

Line: 480

  l_insert_flag      VARCHAR2(1)               := 'N';  --8200511

Line: 591

	     SELECT name
	     INTO   l_from_le_name
	     FROM   xle_firstparty_information_v
	     WHERE  legal_entity_id = p_from_le;

Line: 596

	     SELECT name
	     INTO   l_to_le_name
	     FROM   xle_firstparty_information_v
	     WHERE  legal_entity_id = p_to_le;

Line: 768

	SELECT count(1)
	INTO l_check_ccid
	FROM   gl_code_combinations cc
	WHERE  x_ccid = cc.code_combination_id
	   AND cc.detail_posting_allowed_flag = 'Y'
	   AND cc.enabled_flag = 'Y'
	   AND cc.summary_flag = 'N'
	   AND Nvl(cc.reference3,'N') = 'N'
	   AND cc.template_id IS NULL
	   AND (Trunc(p_gl_date) BETWEEN
			Trunc(Nvl(cc.start_date_active,p_gl_date)) AND
			Trunc(Nvl(cc.end_date_active,p_gl_date)));

Line: 831

	SELECT count(1)
	INTO l_check_ccid
	FROM   gl_code_combinations cc
	WHERE  x_reciprocal_ccid = cc.code_combination_id
	   AND cc.detail_posting_allowed_flag = 'Y'
	   AND cc.enabled_flag = 'Y'
	   AND cc.summary_flag = 'N'
	   AND Nvl(cc.reference3,'N') = 'N'
	   AND cc.template_id IS NULL
	   AND (Trunc(p_gl_date) BETWEEN
			Trunc(Nvl(cc.start_date_active,p_gl_date)) AND
			Trunc(Nvl(cc.end_date_active,p_gl_date)));

Line: 864

		SELECT 'Y' INTO l_insert_flag
			FROM FUN_INTER_ACCOUNTS_V
			WHERE FROM_LE_ID = p_from_le
			AND LEDGER_ID = p_ledger_id
			AND TO_LE_ID = p_to_le
			AND CCID = x_ccid
			AND TYPE = p_acct_type
			AND TRANS_BSV = p_from_bsv
			AND TP_BSV = p_to_bsv;

Line: 875

				l_insert_flag := 'N';

Line: 877

				l_insert_flag := 'Y';

Line: 879

	      IF (l_insert_flag = 'N') THEN
			INSERT INTO FUN_INTER_ACCOUNTS_ADDL(FROM_LE_ID
				,      LEDGER_ID
				,      TO_LE_ID
				,      CCID
				,      TYPE
				,      START_DATE
				,      DEFAULT_FLAG
				,      OBJECT_VERSION_NUMBER
				,      CREATED_BY
				,      CREATION_DATE
				,      LAST_UPDATED_BY
				,      LAST_UPDATE_DATE
				,      LAST_UPDATE_LOGIN
				,      TRANS_BSV
				,      TP_BSV
				)
				VALUES(p_from_le
				,      p_ledger_id
				,      p_to_le
				,      x_ccid
				,      p_acct_type
				,      SYSDATE
				,      NULL
				,      1
				,      FND_GLOBAL.USER_ID
				,      SYSDATE
				,      FND_GLOBAL.USER_ID
				,      SYSDATE
				,      fnd_global.login_id
				,      p_from_bsv
				,      p_to_bsv
				);

Line: 915

		SELECT 'Y' INTO l_insert_flag
			FROM FUN_INTER_ACCOUNTS_V
			WHERE FROM_LE_ID = p_to_le
			AND LEDGER_ID = p_to_ledger_id
			AND TO_LE_ID = p_from_le
			AND CCID = x_reciprocal_ccid
			AND TYPE = l_recip_acct_type
			AND TRANS_BSV = p_to_bsv
			AND TP_BSV = p_from_bsv;

Line: 926

				l_insert_flag := 'N';

Line: 928

				l_insert_flag := 'Y';

Line: 930

	      IF (l_insert_flag = 'N' AND nvl(x_reciprocal_ccid, 0) > 0) THEN
			INSERT INTO FUN_INTER_ACCOUNTS_ADDL(FROM_LE_ID
				,      LEDGER_ID
				,      TO_LE_ID
				,      CCID
				,      TYPE
				,      START_DATE
				,      DEFAULT_FLAG
				,      OBJECT_VERSION_NUMBER
				,      CREATED_BY
				,      CREATION_DATE
				,      LAST_UPDATED_BY
				,      LAST_UPDATE_DATE
				,      LAST_UPDATE_LOGIN
				,      TRANS_BSV
				,      TP_BSV
				)
				VALUES(p_to_le
				,      p_to_ledger_id
				,      p_from_le
				,      x_reciprocal_ccid
				,      l_recip_acct_type
				,      SYSDATE
				,      NULL
				,      1
				,      FND_GLOBAL.USER_ID
				,      SYSDATE
				,      FND_GLOBAL.USER_ID
				,      SYSDATE
				,      fnd_global.login_id
				,      p_to_bsv
				,      p_from_bsv
				);

Line: 977

    SELECT count(1)
	INTO l_check_ccid
	FROM   gl_code_combinations cc
	WHERE  x_ccid = cc.code_combination_id
	   AND cc.detail_posting_allowed_flag = 'Y'
	   AND cc.enabled_flag = 'Y'
	   AND cc.summary_flag = 'N'
	   AND Nvl(cc.reference3,'N') = 'N'
	   AND cc.template_id IS NULL
	   AND (Trunc(p_gl_date) BETWEEN
			Trunc(Nvl(cc.start_date_active,p_gl_date)) AND
			Trunc(Nvl(cc.end_date_active,p_gl_date)));

Line: 1000

	SELECT count(1)
	INTO l_check_ccid
	FROM   gl_code_combinations cc
	WHERE  x_reciprocal_ccid = cc.code_combination_id
	   AND cc.detail_posting_allowed_flag = 'Y'
	   AND cc.enabled_flag = 'Y'
	   AND cc.summary_flag = 'N'
	   AND Nvl(cc.reference3,'N') = 'N'
	   AND cc.template_id IS NULL
	   AND (Trunc(p_gl_date) BETWEEN
			Trunc(Nvl(cc.start_date_active,p_gl_date)) AND
			Trunc(Nvl(cc.end_date_active,p_gl_date)));

Line: 1140

SELECT  NVL((SELECT opts.template_id
             FROM  fun_balance_options opts
             WHERE opts.ledger_id        = p_ledger_id
             AND   Nvl(opts.le_id,-99)   = Nvl(p_le_id,-99)
             AND   opts.je_source_name   = p_source_name
             AND   opts.je_category_name = p_category_name
             AND   opts.status_flag      = 'Y'),
      NVL((SELECT opts.template_id
             FROM  fun_balance_options opts
             WHERE opts.ledger_id        = p_ledger_id
             AND   Nvl(opts.le_id,-99)   = Nvl(p_le_id,-99)
             AND   opts.je_source_name   = p_source_name
             AND   opts.je_category_name = 'Other'
             AND   opts.status_flag      = 'Y'),
      NVL((SELECT opts.template_id
             FROM  fun_balance_options opts
             WHERE opts.ledger_id        = p_ledger_id
             AND   Nvl(opts.le_id,-99)   = Nvl(p_le_id,-99)
             AND   opts.je_source_name   = 'Other'
             AND   opts.je_category_name = p_category_name
             AND   opts.status_flag      = 'Y'),
      (SELECT opts.template_id
             FROM  fun_balance_options opts
             WHERE opts.ledger_id        = p_ledger_id
             AND   Nvl(opts.le_id,-99)   = Nvl(p_le_id,-99)
             AND   opts.je_source_name   = 'Other'
             AND   opts.je_category_name = 'Other'
             AND   opts.status_flag      = 'Y')))) template_id
  From Dual;

Line: 1175

SELECT  NVL((SELECT DECODE (p_acct_type, 'D', accts.dr_ccid, 'C', cr_ccid)
             FROM  fun_balance_accounts accts
             WHERE accts.template_id     = p_template_id
             AND   accts.dr_bsv          = p_dr_bsv
             AND   accts.cr_bsv          = p_cr_bsv),
      NVL((SELECT DECODE (p_acct_type, 'D', accts.dr_ccid, 'C', cr_ccid)
             FROM  fun_balance_accounts accts
             WHERE accts.template_id     = p_template_id
             AND   accts.dr_bsv          = p_dr_bsv
             AND   accts.cr_bsv          = 'OTHER1234567890123456789012345'),
      NVL((SELECT DECODE (p_acct_type, 'D', accts.dr_ccid, 'C', cr_ccid)
             FROM  fun_balance_accounts accts
             WHERE accts.template_id     = p_template_id
             AND   accts.dr_bsv          = 'OTHER1234567890123456789012345'
             AND   accts.cr_bsv          = p_cr_bsv),
      (SELECT DECODE (p_acct_type, 'D', accts.dr_ccid, 'C', cr_ccid)
             FROM  fun_balance_accounts accts
             WHERE accts.template_id     = p_template_id
             AND   accts.dr_bsv          = 'OTHER1234567890123456789012345'
             AND   accts.cr_bsv          = 'OTHER1234567890123456789012345')))) ccid
  From Dual;

Line: 1448

	SELECT count(1)
	INTO l_check_ccid
	FROM   gl_code_combinations cc
	WHERE  x_ccid = cc.code_combination_id
	   AND cc.detail_posting_allowed_flag = 'Y'
	   AND cc.enabled_flag = 'Y'
	   AND cc.summary_flag = 'N'
	   AND Nvl(cc.reference3,'N') = 'N'
	   AND cc.template_id IS NULL
	   AND (Trunc(p_gl_date) BETWEEN
			Trunc(Nvl(cc.start_date_active,p_gl_date)) AND
			Trunc(Nvl(cc.end_date_active,p_gl_date)));

Line: 1470

	SELECT count(1)
	INTO l_check_ccid
	FROM   gl_code_combinations cc
	WHERE  x_reciprocal_ccid = cc.code_combination_id
	   AND cc.detail_posting_allowed_flag = 'Y'
	   AND cc.enabled_flag = 'Y'
	   AND cc.summary_flag = 'N'
	   AND Nvl(cc.reference3,'N') = 'N'
	   AND cc.template_id IS NULL
	   AND (Trunc(p_gl_date) BETWEEN
			Trunc(Nvl(cc.start_date_active,p_gl_date)) AND
			Trunc(Nvl(cc.end_date_active,p_gl_date)));