APPS.GMF_SUBLED_REP_PKG dependencies on MTL_PARAMETERS

Line 120: l_org_cd mtl_parameters.organization_code%TYPE :='';

116:
117: -- get the organization code
118: FUNCTION get_organization_code (p_org_id IN NUMBER, p_ref_no IN NUMBER) RETURN VARCHAR2 IS
119:
120: l_org_cd mtl_parameters.organization_code%TYPE :='';
121: BEGIN
122: IF p_org_id IS NOT NULL THEN
123: SELECT organization_code INTO l_org_cd FROM mtl_parameters WHERE organization_id = p_org_id;
124: ELSIF p_ref_no IS NOT NULL THEN

Line 123: SELECT organization_code INTO l_org_cd FROM mtl_parameters WHERE organization_id = p_org_id;

119:
120: l_org_cd mtl_parameters.organization_code%TYPE :='';
121: BEGIN
122: IF p_org_id IS NOT NULL THEN
123: SELECT organization_code INTO l_org_cd FROM mtl_parameters WHERE organization_id = p_org_id;
124: ELSIF p_ref_no IS NOT NULL THEN
125: SELECT DISTINCT organization_code INTO l_org_cd FROM mtl_parameters mp, gmf_xla_extract_headers eh
126: WHERE mp.organization_id = eh.organization_id AND eh.reference_no = p_ref_no;
127: END IF;

Line 125: SELECT DISTINCT organization_code INTO l_org_cd FROM mtl_parameters mp, gmf_xla_extract_headers eh

121: BEGIN
122: IF p_org_id IS NOT NULL THEN
123: SELECT organization_code INTO l_org_cd FROM mtl_parameters WHERE organization_id = p_org_id;
124: ELSIF p_ref_no IS NOT NULL THEN
125: SELECT DISTINCT organization_code INTO l_org_cd FROM mtl_parameters mp, gmf_xla_extract_headers eh
126: WHERE mp.organization_id = eh.organization_id AND eh.reference_no = p_ref_no;
127: END IF;
128:
129: RETURN l_org_cd;