DBA Data[Home] [Help]

APPS.HXC_HPH_UPLOAD_PKG dependencies on HXC_RETRIEVAL_RULE_GROUPS_V

Line 117: FROM hxc_retrieval_rule_groups_v rrg

113: WHERE aps.application_set_name = p_attribute;
114:
115: CURSOR csr_get_retrieval_rule_grp_id IS
116: SELECT TO_CHAR(rrg.retrieval_rule_group_id)
117: FROM hxc_retrieval_rule_groups_v rrg
118: WHERE rrg.retrieval_rule_group_name = p_attribute;
119:
120: CURSOR csr_get_approval_period_id IS
121: SELECT TO_CHAR(aps.approval_period_set_id)

Line 449: FROM hxc_retrieval_rule_groups_v

445: WHERE application_set_id = TO_NUMBER(p_attribute);
446:
447: CURSOR csr_get_retrieval_rule_grp IS
448: SELECT retrieval_rule_group_name
449: FROM hxc_retrieval_rule_groups_v
450: WHERE retrieval_rule_group_id = TO_NUMBER(p_attribute);
451:
452: CURSOR csr_get_alias IS
453: SELECT alias_definition_name