[Home] [Help]
41: 06 Jul 00 G Perry Changed comment text to 32000 for
42: WWBUG 1382371.
43: 17 Jul 01 M Enderby Addition of ADE related pipe code
44: 05 Feb 02 G Sayers Added dbdrv and commit to comply with
45: GSCC Standards.
46: 05-Dec-2002 A.Holt NOCOPY Performance Changes for 11.5.9
47: 01-Jul-2003 tvankayl procedure Get_customized_restriction modified
48: to take values from PAY_CUSTOM_RESTRICTIONS_VL instead of
49: PAY_CUSTOMIZED_RESTRICTIONS.
104: p_business_group_id in number,
105: p_legislation_code in varchar2,
106: p_application_id out nocopy number,
107: p_query_title out nocopy varchar2,
108: p_standard_title out nocopy varchar2,
109: p_customized_restriction_id out nocopy number,
110: p_message_name out nocopy varchar2) is
111: --
112: cursor csr_restriction is
111: --
112: cursor csr_restriction is
113: select application_id,
114: query_form_title,
115: standard_form_title,
116: enabled_flag,
117: customized_restriction_id
118: from pay_custom_restrictions_vl
119: where name = p_restriction_name
140: fetch csr_restriction into
141: --
142: p_application_id,
143: p_query_title,
144: p_standard_title,
145: l_enabled_flag,
146: p_customized_restriction_id;
147: --
148: hr_utility.set_location ('hr_gen_pkg.GET_CUSTOMIZED_RESTRICTION',2);