APPS.FTE_ACS_CACHE_PKG dependencies on FTE_SEL_GROUP_ATTRIBUTES

Line 754: FROM fte_sel_group_attributes

750: --Check this query
751: --
752: CURSOR c_get_group_attributes IS
753: SELECT attribute_name,attribute_uom_code
754: FROM fte_sel_group_attributes
755: WHERE group_id = p_group_id;
756:
757: itr NUMBER;
758:

Line 812: -- FTE_SEL_GROUP_ATTRIBUTES has 'FROM_REGION_COUNTRY'

808: END IF;
809:
810: --
811: -- FTE_SEL_RULE_RESTICTIONS has FROM_REGION_ID
812: -- FTE_SEL_GROUP_ATTRIBUTES has 'FROM_REGION_COUNTRY'
813: --
814: ELSIF (l_attr_tab(itr).attr_code IN ('FROM_REGION_COUNTRY','FROM_REGION_STATE','FROM_REGION_CITY','FROM_ZONE','FROM_REGION')) THEN
815:
816: -- R12 UI enters 'FROM_REGION' for postal codes also.

Line 831: -- FTE_SEL_GROUP_ATTRIBUTES has 'TO_REGION_COUNTRY'

827: END IF;
828:
829: --
830: -- FTE_SEL_RULE_RESTRICTIONS has TO_REGION_ID
831: -- FTE_SEL_GROUP_ATTRIBUTES has 'TO_REGION_COUNTRY'
832: --
833: ELSIF (l_attr_tab(itr).attr_code IN ('TO_REGION_COUNTRY','TO_REGION_STATE','TO_REGION_CITY','TO_ZONE','TO_REGION')) THEN
834: l_group_attr(g_to_reg_idx) := g_value_present;
835: