APPS.JAI_RCV_ACCOUNTING_PKG dependencies on MTL_PARAMETERS

Line 1023: || FROM mtl_parameters

1019: || AND organization_id = cp_organization_id
1020: || AND cost_element_id = 2 --Indicates Material OverHead
1021: || AND basis_type = 5 --Total Value Basis
1022: || AND cost_type_id = (SELECT avg_rates_cost_type_id
1023: || FROM mtl_parameters
1024: || WHERE organization_id = cp_organization_id
1025: || ); */
1026:
1027: CURSOR c_fetch_overhead_rate(cp_organization_id in number, cp_item_id in number) IS

Line 1036: FROM mtl_parameters c

1032: AND a.inventory_item_id = cp_item_id
1033: AND a.cost_element_id = 2 --Indicates Material OverHead
1034: AND a.basis_type = 5 --Total Value Basis
1035: AND a.cost_type_id = (SELECT c.avg_rates_cost_type_id
1036: FROM mtl_parameters c
1037: WHERE c.organization_id = cp_organization_id
1038: )
1039: ORDER BY a.resource_id;
1040:

Line 1054: from mtl_parameters mp

1050: );
1051:
1052: cursor c_get_accounts(cp_organization_id IN NUMBER) is
1053: select mp.default_cost_group_id
1054: from mtl_parameters mp
1055: where mp.organization_id = cp_organization_id
1056: and mp.primary_cost_method = 2; --Average
1057:
1058: r_get_accounts c_get_accounts%ROWTYPE;