APPS.CTO_AUTO_PROCURE_PK dependencies on MRP_SOURCING_RULES

Line 3799: from mrp_sourcing_rules msr,

3795: select msro.effective_date,
3796: msro.disable_date
3797: into x_start_date,
3798: x_end_date
3799: from mrp_sourcing_rules msr,
3800: mrp_sr_receipt_org msro
3801: where msr.sourcing_rule_id = msro.sourcing_rule_id
3802: and msr.sourcing_rule_id = l_sourcing_rule_id
3803: and trunc(sysdate) between trunc(nvl(msro.effective_date,sysdate)) and trunc(nvl(msro.disable_date,sysdate+1));