APPS.XTR_HEDGE_PROCESS_P dependencies on XTR_COMPANY_PARAMETERS

Line 807: from XTR_COMPANY_PARAMETERS

803: l_dummy VARCHAR2(30) := 'N';
804:
805: cursor param is
806: select parameter_value_code
807: from XTR_COMPANY_PARAMETERS
808: where company_code = p_company
809: and parameter_code = 'ACCNT_BTEST';
810:
811: Begin

Line 932: and exists (select 'Y' from XTR_COMPANY_PARAMETERS

928: where e.batch_id = r.batch_id and
929: e.event_code = 'RETROET')
930: and batch_id in (select batch_id from xtr_batches b where
931: b.period_end <= p_cb_end_date)
932: and exists (select 'Y' from XTR_COMPANY_PARAMETERS
933: where company_code = p_company
934: and parameter_code = 'ACCNT_BTEST'
935: and parameter_value_code = 'Y')
936: and deal_type = 'HEDGE'

Line 963: and exists (select 'Y' from XTR_COMPANY_PARAMETERS

959: where e.batch_id = r.batch_id and
960: e.event_code = 'RETROET')
961: and batch_id in (select batch_id from xtr_batches b where
962: b.period_end <= p_cb_end_date)
963: and exists (select 'Y' from XTR_COMPANY_PARAMETERS
964: where company_code = p_company
965: and parameter_code = 'ACCNT_BTEST'
966: and parameter_value_code = 'Y')
967: UNION

Line 985: and exists (select 'Y' from XTR_COMPANY_PARAMETERS

981: and h.company_code = p_company
982: and r.reclass_date <= p_cb_end_date
983: and r.reclass_date > nvl(p_pb_end_date, r.reclass_date - 5)
984: and h.hedge_status not in ('DESIGNATE', 'CANCELLED')
985: and exists (select 'Y' from XTR_COMPANY_PARAMETERS
986: where company_code = p_company
987: and parameter_code = 'ACCNT_BTEST'
988: and parameter_value_code = 'Y')
989: and retro_batch_id is NULL