APPS.OKC_RGP_PVT dependencies on OKC_RULE_GROUPS_BH

Line 974: FROM OKC_RULE_GROUPS_BH B

970: );
971: DELETE FROM OKC_RULE_GROUPS_TLH T
972: WHERE NOT EXISTS (
973: SELECT NULL
974: FROM OKC_RULE_GROUPS_BH B
975: WHERE B.ID = T.ID
976: AND B.MAJOR_VERSION = T.MAJOR_VERSION
977: );
978:

Line 3846: INSERT INTO okc_rule_groups_bh

3842:
3843: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
3844:
3845: BEGIN
3846: INSERT INTO okc_rule_groups_bh
3847: (
3848: major_version,
3849: id,
3850: rgd_code,

Line 4007: FROM okc_rule_groups_bh

4003: last_update_date,
4004: last_update_login
4005: FROM okc_rule_groups_tlh
4006: WHERE id in (SELECT id
4007: FROM okc_rule_groups_bh
4008: WHERE dnz_chr_id = p_chr_id)
4009: AND major_version = p_major_version;
4010:
4011: -----------------------------------------

Line 4079: FROM okc_rule_groups_bh

4075: attribute12,
4076: attribute13,
4077: attribute14,
4078: attribute15
4079: FROM okc_rule_groups_bh
4080: WHERE dnz_chr_id = p_chr_id
4081: AND major_version = p_major_version;
4082:
4083: RETURN l_return_status;