APPS.HR_FORM_TEMPLATES_API dependencies on HR_FORM_TEMPLATES_B

Line 93: (application_id hr_form_templates_b.application_id%TYPE

89: --
90: -- Declare cursors and local variables
91: --
92: Type l_rec_type Is Record
93: (application_id hr_form_templates_b.application_id%TYPE
94: ,form_id hr_form_templates_b.form_id%TYPE
95: ,template_name hr_form_templates_b.template_name%TYPE
96: ,enabled_flag hr_form_templates_b.enabled_flag%TYPE
97: ,legislation_code hr_form_templates_b.legislation_code%TYPE

Line 94: ,form_id hr_form_templates_b.form_id%TYPE

90: -- Declare cursors and local variables
91: --
92: Type l_rec_type Is Record
93: (application_id hr_form_templates_b.application_id%TYPE
94: ,form_id hr_form_templates_b.form_id%TYPE
95: ,template_name hr_form_templates_b.template_name%TYPE
96: ,enabled_flag hr_form_templates_b.enabled_flag%TYPE
97: ,legislation_code hr_form_templates_b.legislation_code%TYPE
98: ,attribute_category hr_form_templates_b.attribute_category%TYPE

Line 95: ,template_name hr_form_templates_b.template_name%TYPE

91: --
92: Type l_rec_type Is Record
93: (application_id hr_form_templates_b.application_id%TYPE
94: ,form_id hr_form_templates_b.form_id%TYPE
95: ,template_name hr_form_templates_b.template_name%TYPE
96: ,enabled_flag hr_form_templates_b.enabled_flag%TYPE
97: ,legislation_code hr_form_templates_b.legislation_code%TYPE
98: ,attribute_category hr_form_templates_b.attribute_category%TYPE
99: ,attribute1 hr_form_templates_b.attribute1%TYPE

Line 96: ,enabled_flag hr_form_templates_b.enabled_flag%TYPE

92: Type l_rec_type Is Record
93: (application_id hr_form_templates_b.application_id%TYPE
94: ,form_id hr_form_templates_b.form_id%TYPE
95: ,template_name hr_form_templates_b.template_name%TYPE
96: ,enabled_flag hr_form_templates_b.enabled_flag%TYPE
97: ,legislation_code hr_form_templates_b.legislation_code%TYPE
98: ,attribute_category hr_form_templates_b.attribute_category%TYPE
99: ,attribute1 hr_form_templates_b.attribute1%TYPE
100: ,attribute2 hr_form_templates_b.attribute2%TYPE

Line 97: ,legislation_code hr_form_templates_b.legislation_code%TYPE

93: (application_id hr_form_templates_b.application_id%TYPE
94: ,form_id hr_form_templates_b.form_id%TYPE
95: ,template_name hr_form_templates_b.template_name%TYPE
96: ,enabled_flag hr_form_templates_b.enabled_flag%TYPE
97: ,legislation_code hr_form_templates_b.legislation_code%TYPE
98: ,attribute_category hr_form_templates_b.attribute_category%TYPE
99: ,attribute1 hr_form_templates_b.attribute1%TYPE
100: ,attribute2 hr_form_templates_b.attribute2%TYPE
101: ,attribute3 hr_form_templates_b.attribute3%TYPE

Line 98: ,attribute_category hr_form_templates_b.attribute_category%TYPE

94: ,form_id hr_form_templates_b.form_id%TYPE
95: ,template_name hr_form_templates_b.template_name%TYPE
96: ,enabled_flag hr_form_templates_b.enabled_flag%TYPE
97: ,legislation_code hr_form_templates_b.legislation_code%TYPE
98: ,attribute_category hr_form_templates_b.attribute_category%TYPE
99: ,attribute1 hr_form_templates_b.attribute1%TYPE
100: ,attribute2 hr_form_templates_b.attribute2%TYPE
101: ,attribute3 hr_form_templates_b.attribute3%TYPE
102: ,attribute4 hr_form_templates_b.attribute4%TYPE

Line 99: ,attribute1 hr_form_templates_b.attribute1%TYPE

95: ,template_name hr_form_templates_b.template_name%TYPE
96: ,enabled_flag hr_form_templates_b.enabled_flag%TYPE
97: ,legislation_code hr_form_templates_b.legislation_code%TYPE
98: ,attribute_category hr_form_templates_b.attribute_category%TYPE
99: ,attribute1 hr_form_templates_b.attribute1%TYPE
100: ,attribute2 hr_form_templates_b.attribute2%TYPE
101: ,attribute3 hr_form_templates_b.attribute3%TYPE
102: ,attribute4 hr_form_templates_b.attribute4%TYPE
103: ,attribute5 hr_form_templates_b.attribute5%TYPE

Line 100: ,attribute2 hr_form_templates_b.attribute2%TYPE

96: ,enabled_flag hr_form_templates_b.enabled_flag%TYPE
97: ,legislation_code hr_form_templates_b.legislation_code%TYPE
98: ,attribute_category hr_form_templates_b.attribute_category%TYPE
99: ,attribute1 hr_form_templates_b.attribute1%TYPE
100: ,attribute2 hr_form_templates_b.attribute2%TYPE
101: ,attribute3 hr_form_templates_b.attribute3%TYPE
102: ,attribute4 hr_form_templates_b.attribute4%TYPE
103: ,attribute5 hr_form_templates_b.attribute5%TYPE
104: ,attribute6 hr_form_templates_b.attribute6%TYPE

Line 101: ,attribute3 hr_form_templates_b.attribute3%TYPE

97: ,legislation_code hr_form_templates_b.legislation_code%TYPE
98: ,attribute_category hr_form_templates_b.attribute_category%TYPE
99: ,attribute1 hr_form_templates_b.attribute1%TYPE
100: ,attribute2 hr_form_templates_b.attribute2%TYPE
101: ,attribute3 hr_form_templates_b.attribute3%TYPE
102: ,attribute4 hr_form_templates_b.attribute4%TYPE
103: ,attribute5 hr_form_templates_b.attribute5%TYPE
104: ,attribute6 hr_form_templates_b.attribute6%TYPE
105: ,attribute7 hr_form_templates_b.attribute7%TYPE

Line 102: ,attribute4 hr_form_templates_b.attribute4%TYPE

98: ,attribute_category hr_form_templates_b.attribute_category%TYPE
99: ,attribute1 hr_form_templates_b.attribute1%TYPE
100: ,attribute2 hr_form_templates_b.attribute2%TYPE
101: ,attribute3 hr_form_templates_b.attribute3%TYPE
102: ,attribute4 hr_form_templates_b.attribute4%TYPE
103: ,attribute5 hr_form_templates_b.attribute5%TYPE
104: ,attribute6 hr_form_templates_b.attribute6%TYPE
105: ,attribute7 hr_form_templates_b.attribute7%TYPE
106: ,attribute8 hr_form_templates_b.attribute8%TYPE

Line 103: ,attribute5 hr_form_templates_b.attribute5%TYPE

99: ,attribute1 hr_form_templates_b.attribute1%TYPE
100: ,attribute2 hr_form_templates_b.attribute2%TYPE
101: ,attribute3 hr_form_templates_b.attribute3%TYPE
102: ,attribute4 hr_form_templates_b.attribute4%TYPE
103: ,attribute5 hr_form_templates_b.attribute5%TYPE
104: ,attribute6 hr_form_templates_b.attribute6%TYPE
105: ,attribute7 hr_form_templates_b.attribute7%TYPE
106: ,attribute8 hr_form_templates_b.attribute8%TYPE
107: ,attribute9 hr_form_templates_b.attribute9%TYPE

Line 104: ,attribute6 hr_form_templates_b.attribute6%TYPE

100: ,attribute2 hr_form_templates_b.attribute2%TYPE
101: ,attribute3 hr_form_templates_b.attribute3%TYPE
102: ,attribute4 hr_form_templates_b.attribute4%TYPE
103: ,attribute5 hr_form_templates_b.attribute5%TYPE
104: ,attribute6 hr_form_templates_b.attribute6%TYPE
105: ,attribute7 hr_form_templates_b.attribute7%TYPE
106: ,attribute8 hr_form_templates_b.attribute8%TYPE
107: ,attribute9 hr_form_templates_b.attribute9%TYPE
108: ,attribute10 hr_form_templates_b.attribute10%TYPE

Line 105: ,attribute7 hr_form_templates_b.attribute7%TYPE

101: ,attribute3 hr_form_templates_b.attribute3%TYPE
102: ,attribute4 hr_form_templates_b.attribute4%TYPE
103: ,attribute5 hr_form_templates_b.attribute5%TYPE
104: ,attribute6 hr_form_templates_b.attribute6%TYPE
105: ,attribute7 hr_form_templates_b.attribute7%TYPE
106: ,attribute8 hr_form_templates_b.attribute8%TYPE
107: ,attribute9 hr_form_templates_b.attribute9%TYPE
108: ,attribute10 hr_form_templates_b.attribute10%TYPE
109: ,attribute11 hr_form_templates_b.attribute11%TYPE

Line 106: ,attribute8 hr_form_templates_b.attribute8%TYPE

102: ,attribute4 hr_form_templates_b.attribute4%TYPE
103: ,attribute5 hr_form_templates_b.attribute5%TYPE
104: ,attribute6 hr_form_templates_b.attribute6%TYPE
105: ,attribute7 hr_form_templates_b.attribute7%TYPE
106: ,attribute8 hr_form_templates_b.attribute8%TYPE
107: ,attribute9 hr_form_templates_b.attribute9%TYPE
108: ,attribute10 hr_form_templates_b.attribute10%TYPE
109: ,attribute11 hr_form_templates_b.attribute11%TYPE
110: ,attribute12 hr_form_templates_b.attribute12%TYPE

Line 107: ,attribute9 hr_form_templates_b.attribute9%TYPE

103: ,attribute5 hr_form_templates_b.attribute5%TYPE
104: ,attribute6 hr_form_templates_b.attribute6%TYPE
105: ,attribute7 hr_form_templates_b.attribute7%TYPE
106: ,attribute8 hr_form_templates_b.attribute8%TYPE
107: ,attribute9 hr_form_templates_b.attribute9%TYPE
108: ,attribute10 hr_form_templates_b.attribute10%TYPE
109: ,attribute11 hr_form_templates_b.attribute11%TYPE
110: ,attribute12 hr_form_templates_b.attribute12%TYPE
111: ,attribute13 hr_form_templates_b.attribute13%TYPE

Line 108: ,attribute10 hr_form_templates_b.attribute10%TYPE

104: ,attribute6 hr_form_templates_b.attribute6%TYPE
105: ,attribute7 hr_form_templates_b.attribute7%TYPE
106: ,attribute8 hr_form_templates_b.attribute8%TYPE
107: ,attribute9 hr_form_templates_b.attribute9%TYPE
108: ,attribute10 hr_form_templates_b.attribute10%TYPE
109: ,attribute11 hr_form_templates_b.attribute11%TYPE
110: ,attribute12 hr_form_templates_b.attribute12%TYPE
111: ,attribute13 hr_form_templates_b.attribute13%TYPE
112: ,attribute14 hr_form_templates_b.attribute14%TYPE

Line 109: ,attribute11 hr_form_templates_b.attribute11%TYPE

105: ,attribute7 hr_form_templates_b.attribute7%TYPE
106: ,attribute8 hr_form_templates_b.attribute8%TYPE
107: ,attribute9 hr_form_templates_b.attribute9%TYPE
108: ,attribute10 hr_form_templates_b.attribute10%TYPE
109: ,attribute11 hr_form_templates_b.attribute11%TYPE
110: ,attribute12 hr_form_templates_b.attribute12%TYPE
111: ,attribute13 hr_form_templates_b.attribute13%TYPE
112: ,attribute14 hr_form_templates_b.attribute14%TYPE
113: ,attribute15 hr_form_templates_b.attribute15%TYPE

Line 110: ,attribute12 hr_form_templates_b.attribute12%TYPE

106: ,attribute8 hr_form_templates_b.attribute8%TYPE
107: ,attribute9 hr_form_templates_b.attribute9%TYPE
108: ,attribute10 hr_form_templates_b.attribute10%TYPE
109: ,attribute11 hr_form_templates_b.attribute11%TYPE
110: ,attribute12 hr_form_templates_b.attribute12%TYPE
111: ,attribute13 hr_form_templates_b.attribute13%TYPE
112: ,attribute14 hr_form_templates_b.attribute14%TYPE
113: ,attribute15 hr_form_templates_b.attribute15%TYPE
114: ,attribute16 hr_form_templates_b.attribute16%TYPE

Line 111: ,attribute13 hr_form_templates_b.attribute13%TYPE

107: ,attribute9 hr_form_templates_b.attribute9%TYPE
108: ,attribute10 hr_form_templates_b.attribute10%TYPE
109: ,attribute11 hr_form_templates_b.attribute11%TYPE
110: ,attribute12 hr_form_templates_b.attribute12%TYPE
111: ,attribute13 hr_form_templates_b.attribute13%TYPE
112: ,attribute14 hr_form_templates_b.attribute14%TYPE
113: ,attribute15 hr_form_templates_b.attribute15%TYPE
114: ,attribute16 hr_form_templates_b.attribute16%TYPE
115: ,attribute17 hr_form_templates_b.attribute17%TYPE

Line 112: ,attribute14 hr_form_templates_b.attribute14%TYPE

108: ,attribute10 hr_form_templates_b.attribute10%TYPE
109: ,attribute11 hr_form_templates_b.attribute11%TYPE
110: ,attribute12 hr_form_templates_b.attribute12%TYPE
111: ,attribute13 hr_form_templates_b.attribute13%TYPE
112: ,attribute14 hr_form_templates_b.attribute14%TYPE
113: ,attribute15 hr_form_templates_b.attribute15%TYPE
114: ,attribute16 hr_form_templates_b.attribute16%TYPE
115: ,attribute17 hr_form_templates_b.attribute17%TYPE
116: ,attribute18 hr_form_templates_b.attribute18%TYPE

Line 113: ,attribute15 hr_form_templates_b.attribute15%TYPE

109: ,attribute11 hr_form_templates_b.attribute11%TYPE
110: ,attribute12 hr_form_templates_b.attribute12%TYPE
111: ,attribute13 hr_form_templates_b.attribute13%TYPE
112: ,attribute14 hr_form_templates_b.attribute14%TYPE
113: ,attribute15 hr_form_templates_b.attribute15%TYPE
114: ,attribute16 hr_form_templates_b.attribute16%TYPE
115: ,attribute17 hr_form_templates_b.attribute17%TYPE
116: ,attribute18 hr_form_templates_b.attribute18%TYPE
117: ,attribute19 hr_form_templates_b.attribute19%TYPE

Line 114: ,attribute16 hr_form_templates_b.attribute16%TYPE

110: ,attribute12 hr_form_templates_b.attribute12%TYPE
111: ,attribute13 hr_form_templates_b.attribute13%TYPE
112: ,attribute14 hr_form_templates_b.attribute14%TYPE
113: ,attribute15 hr_form_templates_b.attribute15%TYPE
114: ,attribute16 hr_form_templates_b.attribute16%TYPE
115: ,attribute17 hr_form_templates_b.attribute17%TYPE
116: ,attribute18 hr_form_templates_b.attribute18%TYPE
117: ,attribute19 hr_form_templates_b.attribute19%TYPE
118: ,attribute20 hr_form_templates_b.attribute20%TYPE

Line 115: ,attribute17 hr_form_templates_b.attribute17%TYPE

111: ,attribute13 hr_form_templates_b.attribute13%TYPE
112: ,attribute14 hr_form_templates_b.attribute14%TYPE
113: ,attribute15 hr_form_templates_b.attribute15%TYPE
114: ,attribute16 hr_form_templates_b.attribute16%TYPE
115: ,attribute17 hr_form_templates_b.attribute17%TYPE
116: ,attribute18 hr_form_templates_b.attribute18%TYPE
117: ,attribute19 hr_form_templates_b.attribute19%TYPE
118: ,attribute20 hr_form_templates_b.attribute20%TYPE
119: ,attribute21 hr_form_templates_b.attribute21%TYPE

Line 116: ,attribute18 hr_form_templates_b.attribute18%TYPE

112: ,attribute14 hr_form_templates_b.attribute14%TYPE
113: ,attribute15 hr_form_templates_b.attribute15%TYPE
114: ,attribute16 hr_form_templates_b.attribute16%TYPE
115: ,attribute17 hr_form_templates_b.attribute17%TYPE
116: ,attribute18 hr_form_templates_b.attribute18%TYPE
117: ,attribute19 hr_form_templates_b.attribute19%TYPE
118: ,attribute20 hr_form_templates_b.attribute20%TYPE
119: ,attribute21 hr_form_templates_b.attribute21%TYPE
120: ,attribute22 hr_form_templates_b.attribute22%TYPE

Line 117: ,attribute19 hr_form_templates_b.attribute19%TYPE

113: ,attribute15 hr_form_templates_b.attribute15%TYPE
114: ,attribute16 hr_form_templates_b.attribute16%TYPE
115: ,attribute17 hr_form_templates_b.attribute17%TYPE
116: ,attribute18 hr_form_templates_b.attribute18%TYPE
117: ,attribute19 hr_form_templates_b.attribute19%TYPE
118: ,attribute20 hr_form_templates_b.attribute20%TYPE
119: ,attribute21 hr_form_templates_b.attribute21%TYPE
120: ,attribute22 hr_form_templates_b.attribute22%TYPE
121: ,attribute23 hr_form_templates_b.attribute23%TYPE

Line 118: ,attribute20 hr_form_templates_b.attribute20%TYPE

114: ,attribute16 hr_form_templates_b.attribute16%TYPE
115: ,attribute17 hr_form_templates_b.attribute17%TYPE
116: ,attribute18 hr_form_templates_b.attribute18%TYPE
117: ,attribute19 hr_form_templates_b.attribute19%TYPE
118: ,attribute20 hr_form_templates_b.attribute20%TYPE
119: ,attribute21 hr_form_templates_b.attribute21%TYPE
120: ,attribute22 hr_form_templates_b.attribute22%TYPE
121: ,attribute23 hr_form_templates_b.attribute23%TYPE
122: ,attribute24 hr_form_templates_b.attribute24%TYPE

Line 119: ,attribute21 hr_form_templates_b.attribute21%TYPE

115: ,attribute17 hr_form_templates_b.attribute17%TYPE
116: ,attribute18 hr_form_templates_b.attribute18%TYPE
117: ,attribute19 hr_form_templates_b.attribute19%TYPE
118: ,attribute20 hr_form_templates_b.attribute20%TYPE
119: ,attribute21 hr_form_templates_b.attribute21%TYPE
120: ,attribute22 hr_form_templates_b.attribute22%TYPE
121: ,attribute23 hr_form_templates_b.attribute23%TYPE
122: ,attribute24 hr_form_templates_b.attribute24%TYPE
123: ,attribute25 hr_form_templates_b.attribute25%TYPE

Line 120: ,attribute22 hr_form_templates_b.attribute22%TYPE

116: ,attribute18 hr_form_templates_b.attribute18%TYPE
117: ,attribute19 hr_form_templates_b.attribute19%TYPE
118: ,attribute20 hr_form_templates_b.attribute20%TYPE
119: ,attribute21 hr_form_templates_b.attribute21%TYPE
120: ,attribute22 hr_form_templates_b.attribute22%TYPE
121: ,attribute23 hr_form_templates_b.attribute23%TYPE
122: ,attribute24 hr_form_templates_b.attribute24%TYPE
123: ,attribute25 hr_form_templates_b.attribute25%TYPE
124: ,attribute26 hr_form_templates_b.attribute26%TYPE

Line 121: ,attribute23 hr_form_templates_b.attribute23%TYPE

117: ,attribute19 hr_form_templates_b.attribute19%TYPE
118: ,attribute20 hr_form_templates_b.attribute20%TYPE
119: ,attribute21 hr_form_templates_b.attribute21%TYPE
120: ,attribute22 hr_form_templates_b.attribute22%TYPE
121: ,attribute23 hr_form_templates_b.attribute23%TYPE
122: ,attribute24 hr_form_templates_b.attribute24%TYPE
123: ,attribute25 hr_form_templates_b.attribute25%TYPE
124: ,attribute26 hr_form_templates_b.attribute26%TYPE
125: ,attribute27 hr_form_templates_b.attribute27%TYPE

Line 122: ,attribute24 hr_form_templates_b.attribute24%TYPE

118: ,attribute20 hr_form_templates_b.attribute20%TYPE
119: ,attribute21 hr_form_templates_b.attribute21%TYPE
120: ,attribute22 hr_form_templates_b.attribute22%TYPE
121: ,attribute23 hr_form_templates_b.attribute23%TYPE
122: ,attribute24 hr_form_templates_b.attribute24%TYPE
123: ,attribute25 hr_form_templates_b.attribute25%TYPE
124: ,attribute26 hr_form_templates_b.attribute26%TYPE
125: ,attribute27 hr_form_templates_b.attribute27%TYPE
126: ,attribute28 hr_form_templates_b.attribute28%TYPE

Line 123: ,attribute25 hr_form_templates_b.attribute25%TYPE

119: ,attribute21 hr_form_templates_b.attribute21%TYPE
120: ,attribute22 hr_form_templates_b.attribute22%TYPE
121: ,attribute23 hr_form_templates_b.attribute23%TYPE
122: ,attribute24 hr_form_templates_b.attribute24%TYPE
123: ,attribute25 hr_form_templates_b.attribute25%TYPE
124: ,attribute26 hr_form_templates_b.attribute26%TYPE
125: ,attribute27 hr_form_templates_b.attribute27%TYPE
126: ,attribute28 hr_form_templates_b.attribute28%TYPE
127: ,attribute29 hr_form_templates_b.attribute29%TYPE

Line 124: ,attribute26 hr_form_templates_b.attribute26%TYPE

120: ,attribute22 hr_form_templates_b.attribute22%TYPE
121: ,attribute23 hr_form_templates_b.attribute23%TYPE
122: ,attribute24 hr_form_templates_b.attribute24%TYPE
123: ,attribute25 hr_form_templates_b.attribute25%TYPE
124: ,attribute26 hr_form_templates_b.attribute26%TYPE
125: ,attribute27 hr_form_templates_b.attribute27%TYPE
126: ,attribute28 hr_form_templates_b.attribute28%TYPE
127: ,attribute29 hr_form_templates_b.attribute29%TYPE
128: ,attribute30 hr_form_templates_b.attribute30%TYPE);

Line 125: ,attribute27 hr_form_templates_b.attribute27%TYPE

121: ,attribute23 hr_form_templates_b.attribute23%TYPE
122: ,attribute24 hr_form_templates_b.attribute24%TYPE
123: ,attribute25 hr_form_templates_b.attribute25%TYPE
124: ,attribute26 hr_form_templates_b.attribute26%TYPE
125: ,attribute27 hr_form_templates_b.attribute27%TYPE
126: ,attribute28 hr_form_templates_b.attribute28%TYPE
127: ,attribute29 hr_form_templates_b.attribute29%TYPE
128: ,attribute30 hr_form_templates_b.attribute30%TYPE);
129:

Line 126: ,attribute28 hr_form_templates_b.attribute28%TYPE

122: ,attribute24 hr_form_templates_b.attribute24%TYPE
123: ,attribute25 hr_form_templates_b.attribute25%TYPE
124: ,attribute26 hr_form_templates_b.attribute26%TYPE
125: ,attribute27 hr_form_templates_b.attribute27%TYPE
126: ,attribute28 hr_form_templates_b.attribute28%TYPE
127: ,attribute29 hr_form_templates_b.attribute29%TYPE
128: ,attribute30 hr_form_templates_b.attribute30%TYPE);
129:
130: l_rec l_rec_type;

Line 127: ,attribute29 hr_form_templates_b.attribute29%TYPE

123: ,attribute25 hr_form_templates_b.attribute25%TYPE
124: ,attribute26 hr_form_templates_b.attribute26%TYPE
125: ,attribute27 hr_form_templates_b.attribute27%TYPE
126: ,attribute28 hr_form_templates_b.attribute28%TYPE
127: ,attribute29 hr_form_templates_b.attribute29%TYPE
128: ,attribute30 hr_form_templates_b.attribute30%TYPE);
129:
130: l_rec l_rec_type;
131:

Line 128: ,attribute30 hr_form_templates_b.attribute30%TYPE);

124: ,attribute26 hr_form_templates_b.attribute26%TYPE
125: ,attribute27 hr_form_templates_b.attribute27%TYPE
126: ,attribute28 hr_form_templates_b.attribute28%TYPE
127: ,attribute29 hr_form_templates_b.attribute29%TYPE
128: ,attribute30 hr_form_templates_b.attribute30%TYPE);
129:
130: l_rec l_rec_type;
131:
132: CURSOR cur_tmplt_rec

Line 170: FROM hr_form_templates_b tmp

166: ,DECODE(p_attribute27,hr_api.g_varchar2,tmp.attribute27,p_attribute27)
167: ,DECODE(p_attribute28,hr_api.g_varchar2,tmp.attribute28,p_attribute28)
168: ,DECODE(p_attribute29,hr_api.g_varchar2,tmp.attribute29,p_attribute29)
169: ,DECODE(p_attribute30,hr_api.g_varchar2,tmp.attribute30,p_attribute30)
170: FROM hr_form_templates_b tmp
171: WHERE tmp.form_template_id = p_form_template_id_from;
172:
173: CURSOR cur_tmplt_tl
174: IS