APPS.JG_JGZZTAJA_XMLP_PKG SQL Statements

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

Line: 7

  SELECT 	count(*)
  INTO		CP_ROWS_SELECTED
  FROM 		jg_zz_ta_rule_sets		rs,
 		fnd_lookups			l,
		jg_zz_ta_cc_ranges		cc,
		jg_zz_ta_account_ranges		acc,
		jg_zz_ta_rule_lines		rl
  WHERE		rl.account_range_id 		= acc.account_range_id
  AND		acc.cc_range_id			= cc.cc_range_id
  AND		cc.rule_set_id			= rs.rule_set_id
  AND 		rs.account_type			= l.lookup_code(+)
  AND		NVL(l.lookup_type,'ACCOUNT_TYPE')	= 'ACCOUNT_TYPE'
  AND		rs.rule_set_id			= NVL(P_RULE_SET_ID,rs.rule_set_id);

Line: 22

  SELECT sob.name
  INTO C_SET_OF_BOOKS_NAME
  FROM GL_SETS_OF_BOOKS sob
  WHERE sob.set_of_books_id = P_SET_OF_BOOKS_ID;

Line: 56

  FUNCTION CP_ROWS_SELECTED_P RETURN NUMBER IS
  BEGIN
    RETURN CP_ROWS_SELECTED;

Line: 59

  END CP_ROWS_SELECTED_P;