DBA Data[Home] [Help]

APPS.BIM_RESPONSE_FACTS_PKG dependencies on BIM_R_RESP_INT_HEADER

Line 490: bim_r_resp_int_header a,

486: ,decode(decode(to_char(response_create_date,'MM'),to_char(next_day(response_create_date,TO_NUMBER(to_char(to_date('07/09/2004', 'DD/MM/RRRR'), 'DD'))),'MM'),'TRUE','FALSE')
487: ,'FALSE'
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

Line 567: bim_r_resp_int_header a,

563: ,decode(decode(to_char(response_create_date,'MM'),to_char(next_day(response_create_date,TO_NUMBER(to_char(to_date('07/09/2004', 'DD/MM/RRRR'), 'DD'))),'MM'),'TRUE','FALSE')
564: ,'FALSE'
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