APPS.HR_DYNAMIC_APPROVAL_WEB dependencies on WF_ACTIVITY_ATTR_VALUES

Line 41: gv_approvals_mode wf_activity_attr_values.text_value%TYPE;

37: gn_region_application_id CONSTANT integer := 601;
38: gv_browser_title hr_util_misc_web.g_title%TYPE;
39: gtt_prompts hr_util_misc_web.g_prompts%TYPE;
40: gv_language_code VARCHAR2(200) DEFAULT NULL;
41: gv_approvals_mode wf_activity_attr_values.text_value%TYPE;
42: gv_update_mode wf_activity_attr_values.text_value%TYPE
43: DEFAULT 'OFF';
44: gv_effective_date wf_item_attribute_values.text_value%TYPE;
45: gv_APPROVALS_ACTIVITY_NAME CONSTANT

Line 42: gv_update_mode wf_activity_attr_values.text_value%TYPE

38: gv_browser_title hr_util_misc_web.g_title%TYPE;
39: gtt_prompts hr_util_misc_web.g_prompts%TYPE;
40: gv_language_code VARCHAR2(200) DEFAULT NULL;
41: gv_approvals_mode wf_activity_attr_values.text_value%TYPE;
42: gv_update_mode wf_activity_attr_values.text_value%TYPE
43: DEFAULT 'OFF';
44: gv_effective_date wf_item_attribute_values.text_value%TYPE;
45: gv_APPROVALS_ACTIVITY_NAME CONSTANT
46: wf_item_activity_statuses_v.activity_name%TYPE

Line 154: from WF_ACTIVITY_ATTR_VALUES wfaav

150: , p_id in varchar2
151: )
152: IS
153: select 1
154: from WF_ACTIVITY_ATTR_VALUES wfaav
155: where wfaav.name = p_name
156: and wfaav.PROCESS_ACTIVITY_ID = p_id;
157:
158: