DBA Data[Home] [Help]

APPS.VEA_LAYERS_SV dependencies on VEA_LAYERS_V

Line 1408: vea_layers_v LV

1404: PK.layer_provider_code
1405: FROM vea_program_units PU,
1406: vea_packages PK,
1407: vea_layer_headers LH,
1408: vea_layers_v LV
1409: WHERE PU.tps_flag = 'N'
1410: AND PU.layer_provider_code = PK.layer_provider_code
1411: AND PU.package_id = PK.package_id
1412: AND PU.layer_provider_code = LH.program_unit_lp_code

Line 2063: FROM vea_layers_v

2059: p_layer_header_id IN vea_layers.layer_header_id%TYPE
2060: )
2061: IS
2062: SELECT layer_id, tp_layer_id
2063: FROM vea_layers_v
2064: WHERE layer_provider_code = p_layer_provider_code
2065: AND layer_header_id = p_layer_header_id;
2066: --
2067: --

Line 2164: FROM vea_layers_v LA,

2160: PU.layer_provider_code,
2161: LA.tp_layer_id,
2162: LA.tp_layer_name,
2163: LA.active_flag
2164: FROM vea_layers_v LA,
2165: vea_layer_headers LH,
2166: vea_program_units PU
2167: WHERE LA.layer_provider_code = p_layer_provider_code
2168: AND LH.layer_provider_code = LA.layer_provider_code