APPS.PO_AUTOSOURCE_SV dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 158: -- Get organization_id from financials_system_parameters.

154: */
155:
156: IF x_dest_organization_id IS NULL THEN
157:
158: -- Get organization_id from financials_system_parameters.
159: SELECT inventory_organization_id
160: INTO x_organization_id
161: FROM financials_system_parameters;
162:

Line 161: FROM financials_system_parameters;

157:
158: -- Get organization_id from financials_system_parameters.
159: SELECT inventory_organization_id
160: INTO x_organization_id
161: FROM financials_system_parameters;
162:
163: ELSE
164: x_organization_id := x_dest_organization_id;
165: END IF;

Line 1133: from financials_system_parameters;

1129: x_org_id := null;
1130: else
1131: select org_id
1132: into x_org_id
1133: from financials_system_parameters;
1134: end if;
1135: /* Cto Changes FPH end */
1136:
1137: IF x_organization_id IS NULL THEN

Line 1139: -- Get organization_id from financials_system_parameters.

1135: /* Cto Changes FPH end */
1136:
1137: IF x_organization_id IS NULL THEN
1138:
1139: -- Get organization_id from financials_system_parameters.
1140:
1141: SELECT inventory_organization_id
1142: INTO x_using_organization_id
1143: FROM financials_system_parameters;

Line 1143: FROM financials_system_parameters;

1139: -- Get organization_id from financials_system_parameters.
1140:
1141: SELECT inventory_organization_id
1142: INTO x_using_organization_id
1143: FROM financials_system_parameters;
1144:
1145: ELSE
1146: x_using_organization_id := x_organization_id;
1147: END IF;

Line 4949: -- Get organization_id from financials_system_parameters.

4945: x_conversion_rate := 1;
4946:
4947: IF x_dest_organization_id IS NULL THEN
4948:
4949: -- Get organization_id from financials_system_parameters.
4950:
4951: SELECT inventory_organization_id
4952: INTO x_organization_id
4953: FROM financials_system_parameters;

Line 4953: FROM financials_system_parameters;

4949: -- Get organization_id from financials_system_parameters.
4950:
4951: SELECT inventory_organization_id
4952: INTO x_organization_id
4953: FROM financials_system_parameters;
4954:
4955: ELSE
4956: x_organization_id := x_dest_organization_id;
4957: END IF;

Line 6155: FROM financials_system_parameters;

6151: SELECT org_id,
6152: inventory_organization_id
6153: INTO l_org_id,
6154: l_using_organization_id
6155: FROM financials_system_parameters;
6156: EXCEPTION
6157: WHEN OTHERS THEN
6158: null;
6159: END;

Line 6772: FROM financials_system_parameters;

6768: -- SQL Why : To calculate the currency conversion rate
6769:
6770: SELECT set_of_books_id
6771: INTO l_sob_id
6772: FROM financials_system_parameters;
6773:
6774: -- SQL What: Get the default currency exchange rate type from system parameters
6775: -- SQL Why : To calculate the currency conversion rate
6776:

Line 6787: FINANCIALS_SYSTEM_PARAMETERS FSP,

6783:
6784: SELECT nvl(FND.extended_precision,5)
6785: INTO l_base_curr_ext_precision
6786: FROM FND_CURRENCIES FND,
6787: FINANCIALS_SYSTEM_PARAMETERS FSP,
6788: GL_SETS_OF_BOOKS GSB
6789: WHERE FSP.set_of_books_id = GSB.set_of_books_id AND
6790: FND.currency_code = GSB.currency_code;
6791: