DBA Data[Home] [Help]

APPS.BIM_RESPONSE_FACTS_PKG dependencies on BIM_R_SOURCE_CODES

Line 492: bim_r_source_codes d

488: ,last_day(response_create_date))))) weekend_date
489: FROM
490: bim_r_resp_int_header a,
491: bim_r_resp_int_grades b,
492: bim_r_source_codes d
493: WHERE a.response_create_date >= p_start_date
494: AND a.response_create_date <= p_end_date
495: AND a.object_id = decode(d.object_type,'CAMP',d.parent_object_id,'EVEH',d.parent_object_id,
496: 'CSCH',d.object_id,'EVEO',d.object_id)

Line 569: bim_r_source_codes d

565: ,last_day(response_create_date))))) weekend_date
566: FROM
567: bim_r_resp_int_header a,
568: bim_r_resp_int_reason b,
569: bim_r_source_codes d
570: WHERE a.response_create_date >= p_start_date
571: AND a.response_create_date <= p_end_date
572: AND a.object_type = d.object_type
573: AND a.object_id = decode(d.object_type,'CAMP',d.parent_object_id,'EVEH',d.parent_object_id,