APPS.PA_ADVERTISEMENTS_PVT dependencies on PA_ACTION_SET_LINE_COND

Line 116: pa_action_set_line_cond aslc,

112: l_condition_attribute1_tbl,
113: l_condition_attribute2_tbl,
114: l_action_line_cond_id_tbl
115: FROM pa_action_set_lines asl,
116: pa_action_set_line_cond aslc,
117: pa_action_sets asets,
118: pa_action_sets asets2
119: WHERE asets2.action_set_id = p_action_set_id
120: AND asets.object_id = asets2.object_id

Line 149: pa_action_set_line_cond aslc

145: l_condition_attribute1_tbl,
146: l_condition_attribute2_tbl,
147: l_action_line_cond_id_tbl
148: FROM pa_action_set_lines asl,
149: pa_action_set_line_cond aslc
150: WHERE asl.action_set_id = p_action_set_id
151: AND asl.action_set_line_id = aslc.action_set_line_id;
152:
153: --dbms_output.put_line('GET CURRENT number of lines: '||l_action_line_id_tbl.COUNT);

Line 1825: pa_action_set_line_cond aslc

1821: CURSOR get_all_reversed_lines IS
1822: SELECT asl.action_set_line_id, asl.action_code, asa.audit_attribute, asa.audit_display_attribute, 'COMPLETE'
1823: FROM pa_action_set_line_aud asa,
1824: pa_action_set_lines asl,
1825: pa_action_set_line_cond aslc
1826: WHERE asa.object_id = p_object_id
1827: AND asa.object_type = 'OPEN_ASSIGNMENT'
1828: AND asa.action_set_type_code = 'ADVERTISEMENT'
1829: AND asa.action_set_line_id = p_action_set_line_id