DBA Data[Home] [Help]

APPS.PA_ASSET_UTILS dependencies on PA_PROJECT_ASSET_LINES

Line 120: from pa_project_asset_lines

116: return number
117: is
118: cursor c1 is
119: select project_asset_id
120: from pa_project_asset_lines
121: where project_asset_id = x_project_asset_id;
122:
123: c1_rec c1%rowtype;
124:

Line 167: pa_project_asset_lines ppal

163: cursor c1 (pa_asset_id NUMBER) is
164: select distinct faa.asset_number
165: from fa_additions faa,
166: fa_asset_invoices fai,
167: pa_project_asset_lines ppal
168: where
169: ppal.project_asset_id = pa_asset_id AND
170: ppal.project_asset_line_id = fai.project_asset_line_id AND
171: fai.asset_id = faa.asset_id;