APPS.OKC_AR_INT_PUB SQL Statements

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

Line: 35

SELECT lookup_code
FROM fnd_lookups
WHERE lookup_type = 'OKC_CONTINGENCY_RULES';

Line: 41

SELECT rule_information1, rule_information2,
       rule_information3, rule_information4
FROM  okc_rule_groups_b rgb,
      okc_rules_b rul
WHERE rgb.id = rul.rgp_id
  AND rgb.rgd_code = 'REVENUE_CONTINGENCY_RULES'
  AND rgb.dnz_chr_id = p_chr_id
  AND rgb.cle_id = p_cle_id
  AND rul.rule_information_category = p_rule_code;

Line: 53

SELECT rule_information1, rule_information2,
       rule_information3, rule_information4
FROM  okc_rule_groups_b rgb,
      okc_rules_b rul
WHERE rgb.id = rul.rgp_id
  AND rgb.rgd_code = 'REVENUE_CONTINGENCY_RULES'
  AND rgb.chr_id = p_chr_id
  AND rul.rule_information_category = p_rule_code;