APPS.FEM_DEFCALP_UTIL_PKG dependencies on FEM_LEDGERS_ATTR

Line 108: v_cal_hier_attribute_id FEM_LEDGERS_ATTR.attribute_id%TYPE;

104: -- Ledger variables
105: v_ledger_id FEM_LEDGERS_B.ledger_id%TYPE;
106: v_boolean BOOLEAN;
107: v_verify_ledger_id FEM_LEDGERS_B.ledger_id%TYPE;
108: v_cal_hier_attribute_id FEM_LEDGERS_ATTR.attribute_id%TYPE;
109: v_cal_hier_version_id FEM_LEDGERS_ATTR.version_id%TYPE;
110:
111: -- Business Relationship variables
112: v_bus_rel_mbr_id NUMBER;

Line 109: v_cal_hier_version_id FEM_LEDGERS_ATTR.version_id%TYPE;

105: v_ledger_id FEM_LEDGERS_B.ledger_id%TYPE;
106: v_boolean BOOLEAN;
107: v_verify_ledger_id FEM_LEDGERS_B.ledger_id%TYPE;
108: v_cal_hier_attribute_id FEM_LEDGERS_ATTR.attribute_id%TYPE;
109: v_cal_hier_version_id FEM_LEDGERS_ATTR.version_id%TYPE;
110:
111: -- Business Relationship variables
112: v_bus_rel_mbr_id NUMBER;
113: v_bus_rel_dim_id NUMBER;

Line 920: FROM fem_ledgers_attr

916: FROM fem_ledgers_b
917: WHERE enabled_flag = 'Y'
918: AND ledger_id IN
919: (SELECT ledger_id
920: FROM fem_ledgers_attr
921: WHERE dim_attribute_numeric_member IN
922: (SELECT object_definition_id
923: FROM fem_object_definition_b
924: WHERE object_id IN

Line 956: FROM fem_ledgers_attr

952: (SELECT object_id
953: FROM fem_object_definition_b
954: WHERE object_definition_id IN
955: (SELECT dim_attribute_numeric_member
956: FROM fem_ledgers_attr
957: WHERE ledger_id = v_ledger_id
958: AND attribute_id = v_cal_hier_attribute_id
959: AND version_id = v_cal_hier_version_id)));
960: END IF;