APPS.CZ_ATP_UTIL dependencies on MTL_PARAMETERS

Line 67: -- if not, take it from mtl parameters by org definition.

63: rec_mgav.atp_rule_id := p_atp_rule_id;
64: end if;
65:
66: -- check if ATP rule ID has been provided or selected from msi table.
67: -- if not, take it from mtl parameters by org definition.
68: begin
69: if rec_mgav.atp_rule_id is null then
70: begin
71: SELECT r.rule_id

Line 75: mtl_parameters p, mtl_atp_rules r

71: SELECT r.rule_id
72: INTO
73: rec_mgav.atp_rule_id
74: FROM
75: mtl_parameters p, mtl_atp_rules r
76: WHERE
77: p.default_atp_rule_id = r.rule_id
78: AND p.organization_id = p_organization_id;
79: exception

Line 96: FROM HR_ORGANIZATION_UNITS HR, MTL_PARAMETERS MTL

92: -- retrieve calendar organization ID
93: begin
94: SELECT MTL.ORGANIZATION_ID
95: into rec_mgav.atp_calendar_organization_id
96: FROM HR_ORGANIZATION_UNITS HR, MTL_PARAMETERS MTL
97: WHERE HR.ORGANIZATION_ID = MTL.ORGANIZATION_ID
98: AND MTL.CALENDAR_CODE is not null
99: AND MTL.CALENDAR_EXCEPTION_SET_ID is not null
100: AND MTL.ORGANIZATION_ID = p_organization_id;