APPS.PA_ACTION_SET_UTILS dependencies on PA_ACTION_SET_LINES

Line 97: FROM pa_action_set_lines

93: l_action_attribute7_tbl,
94: l_action_attribute8_tbl,
95: l_action_attribute9_tbl,
96: l_action_attribute10_tbl
97: FROM pa_action_set_lines
98: WHERE action_set_id = p_action_set_id;
99:
100: IF l_action_set_line_id_tbl.COUNT > 0 THEN
101:

Line 134: RETURN pa_action_set_lines%ROWTYPE

130: END;
131:
132:
133: FUNCTION get_action_set_line (p_action_set_line_id IN NUMBER)
134: RETURN pa_action_set_lines%ROWTYPE
135: IS
136:
137: l_action_set_lines_rec pa_action_set_lines%ROWTYPE;
138:

Line 137: l_action_set_lines_rec pa_action_set_lines%ROWTYPE;

133: FUNCTION get_action_set_line (p_action_set_line_id IN NUMBER)
134: RETURN pa_action_set_lines%ROWTYPE
135: IS
136:
137: l_action_set_lines_rec pa_action_set_lines%ROWTYPE;
138:
139: BEGIN
140:
141: SELECT action_set_line_id,

Line 176: FROM pa_action_set_lines

172: l_action_set_lines_rec.action_attribute7,
173: l_action_set_lines_rec.action_attribute8,
174: l_action_set_lines_rec.action_attribute9,
175: l_action_set_lines_rec.action_attribute10
176: FROM pa_action_set_lines
177: WHERE action_set_line_id = p_action_set_line_id;
178:
179: RETURN l_action_set_lines_rec;
180:

Line 249: pa_action_set_lines lines

245: l_action_sets_rec.attribute13,
246: l_action_sets_rec.attribute14,
247: l_action_sets_rec.attribute15
248: FROM pa_action_sets sets,
249: pa_action_set_lines lines
250: WHERE lines.action_set_line_id = p_action_set_line_id
251: AND lines.action_set_id = sets.action_set_id;
252:
253: RETURN l_action_sets_rec;

Line 550: FROM pa_action_set_lines

546: l_lines_exist VARCHAR2(1);
547:
548: CURSOR do_lines_exist IS
549: SELECT 'X'
550: FROM pa_action_set_lines
551: WHERE action_set_id = p_action_set_id;
552:
553: BEGIN
554: