DBA Data[Home] [Help]

APPS.AR_GTA_ARTRX_PROC dependencies on OE_SYS_PARAMETERS_ALL

Line 2871: FROM oe_sys_parameters_all

2867: --Yao add for bug#9830678
2868: BEGIN
2869: SELECT parameter_value
2870: INTO l_discount_on_invoice
2871: FROM oe_sys_parameters_all
2872: WHERE org_id = p_org_id
2873: AND parameter_code = 'OE_DISCOUNT_DETAILS_ON_INVOICE';
2874: EXCEPTION
2875: --Yao add for bug10243486

Line 3085: FROM oe_sys_parameters_all

3081: --yao zhang fix bug 7829039 add the following code
3082: BEGIN
3083: SELECT parameter_value
3084: INTO l_master_org
3085: FROM oe_sys_parameters_all
3086: WHERE org_id = p_org_id
3087: AND parameter_code = 'MASTER_ORGANIZATION_ID';
3088: EXCEPTION
3089: WHEN no_data_found THEN

Line 3681: FROM oe_sys_parameters_all

3677: --The following code is added by Yao Zhang to retrive Item Validation Organization for ou
3678: BEGIN
3679: SELECT parameter_value
3680: INTO l_master_org
3681: FROM oe_sys_parameters_all
3682: WHERE org_id = p_org_id
3683: AND parameter_code = 'MASTER_ORGANIZATION_ID';
3684: EXCEPTION
3685: WHEN no_data_found THEN