DBA Data[Home] [Help]

APPS.PA_ACTION_SETS_DYN dependencies on PA_ADV_RULE_OBJECTS_V

Line 90: FROM PA_ADV_RULE_OBJECTS_V conc_view,

86: conc_view.project_number
87: BULK COLLECT INTO x_action_set_line_id_tbl,
88: x_object_name_tbl,
89: x_project_number_tbl
90: FROM PA_ADV_RULE_OBJECTS_V conc_view,
91: pa_action_sets asets,
92: pa_action_set_lines alines
93: WHERE project_number BETWEEN p_project_number_from AND p_project_number_to
94: AND conc_view.object_type = asets.object_type

Line 108: FROM PA_ADV_RULE_OBJECTS_V conc_view,

104: conc_view.project_number
105: BULK COLLECT INTO x_action_set_line_id_tbl,
106: x_object_name_tbl,
107: x_project_number_tbl
108: FROM PA_ADV_RULE_OBJECTS_V conc_view,
109: pa_action_sets asets,
110: pa_action_set_lines alines
111: WHERE project_number >= p_project_number_from
112: AND conc_view.object_type = asets.object_type

Line 126: FROM PA_ADV_RULE_OBJECTS_V conc_view,

122: conc_view.project_number
123: BULK COLLECT INTO x_action_set_line_id_tbl,
124: x_object_name_tbl,
125: x_project_number_tbl
126: FROM PA_ADV_RULE_OBJECTS_V conc_view,
127: pa_action_sets asets,
128: pa_action_set_lines alines
129: WHERE project_number <= p_project_number_to
130: AND conc_view.object_type = asets.object_type

Line 144: FROM PA_ADV_RULE_OBJECTS_V conc_view,

140: conc_view.project_number
141: BULK COLLECT INTO x_action_set_line_id_tbl,
142: x_object_name_tbl,
143: x_project_number_tbl
144: FROM PA_ADV_RULE_OBJECTS_V conc_view,
145: pa_action_sets asets,
146: pa_action_set_lines alines
147: WHERE
148: conc_view.object_type = asets.object_type