APPS.CTO_AUTO_PROCURE_PK dependencies on MRP_SOURCING_RULES

Line 4209: from mrp_sourcing_rules msr,

4205: select msro.effective_date,
4206: msro.disable_date
4207: into x_start_date,
4208: x_end_date
4209: from mrp_sourcing_rules msr,
4210: mrp_sr_receipt_org msro
4211: where msr.sourcing_rule_id = msro.sourcing_rule_id
4212: and msr.sourcing_rule_id = l_sourcing_rule_id
4213: and trunc(sysdate) between trunc(nvl(msro.effective_date,sysdate)) and trunc(nvl(msro.disable_date,sysdate+1));