APPS.OKC_RGP_PVT dependencies on OKC_RULE_GROUPS_BH

Line 978: FROM OKC_RULE_GROUPS_BH B

974: );
975: DELETE FROM OKC_RULE_GROUPS_TLH T
976: WHERE NOT EXISTS (
977: SELECT NULL
978: FROM OKC_RULE_GROUPS_BH B
979: WHERE B.ID = T.ID
980: AND B.MAJOR_VERSION = T.MAJOR_VERSION
981: );
982:

Line 3850: INSERT INTO okc_rule_groups_bh

3846:
3847: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
3848:
3849: BEGIN
3850: INSERT INTO okc_rule_groups_bh
3851: (
3852: major_version,
3853: id,
3854: rgd_code,

Line 4011: FROM okc_rule_groups_bh

4007: last_update_date,
4008: last_update_login
4009: FROM okc_rule_groups_tlh
4010: WHERE id in (SELECT id
4011: FROM okc_rule_groups_bh
4012: WHERE dnz_chr_id = p_chr_id)
4013: AND major_version = p_major_version;
4014:
4015: -----------------------------------------

Line 4083: FROM okc_rule_groups_bh

4079: attribute12,
4080: attribute13,
4081: attribute14,
4082: attribute15
4083: FROM okc_rule_groups_bh
4084: WHERE dnz_chr_id = p_chr_id
4085: AND major_version = p_major_version;
4086:
4087: RETURN l_return_status;