APPS.JAI_RCV_ACCOUNTING_PKG dependencies on MTL_PARAMETERS

Line 1080: FROM mtl_parameters

1076: AND organization_id = cp_organization_id
1077: AND cost_element_id = 2 --Indicates Material OverHead
1078: AND basis_type = 5 --Total Value Basis
1079: AND cost_type_id = (SELECT avg_rates_cost_type_id
1080: FROM mtl_parameters
1081: WHERE organization_id = cp_organization_id
1082: );
1083:
1084: CURSOR c_fetch_overhead_rate(cp_organization_id in number, cp_item_id in number) IS

Line 1093: FROM mtl_parameters c

1089: AND a.inventory_item_id = cp_item_id
1090: AND a.cost_element_id = 2 --Indicates Material OverHead
1091: AND a.basis_type = 5 --Total Value Basis
1092: AND a.cost_type_id = (SELECT c.avg_rates_cost_type_id
1093: FROM mtl_parameters c
1094: WHERE c.organization_id = cp_organization_id
1095: )
1096: ORDER BY a.resource_id;
1097:

Line 1114: from mtl_parameters mp

1110: AND organization_id = cp_organization_id; --added for bug#8449597
1111:
1112: cursor c_get_accounts(cp_organization_id IN NUMBER) is
1113: select mp.default_cost_group_id
1114: from mtl_parameters mp
1115: where mp.organization_id = cp_organization_id
1116: and mp.primary_cost_method = 2; --Average
1117:
1118: r_get_accounts c_get_accounts%ROWTYPE;