DBA Data[Home] [Help]

APPS.FA_CUA_HIERARCHY_PKG dependencies on FA_HIERARCHY_CONTROLS

Line 537: from FA_HIERARCHY_CONTROLS

533: CREATION_DATE,
534: LAST_UPDATED_BY,
535: LAST_UPDATE_DATE,
536: LAST_UPDATE_LOGIN
537: from FA_HIERARCHY_CONTROLS
538: where asset_hierarchy_purpose_id = x_asset_hierarchy_purpose_id
539: and level_number = x_level_number;
540: mand_controlrec C_MANDT_CONTROLS%ROWTYPE;
541: l_old_err_stack varchar2(640);

Line 1735: from fa_hierarchy_controls

1731: ,x_attribute_name in varchar2)
1732: return Boolean
1733: is
1734: Cursor C is select 1
1735: from fa_hierarchy_controls
1736: where asset_hierarchy_purpose_id = x_hierarchy_purpose_id
1737: and level_number = x_level_number
1738: and nvl(decode(x_attribute_name,'CATEGORY',category_mandatory_flag
1739: ,'LEASE',lease_mandatory_flag