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 1137: from financials_system_parameters;

1133: x_org_id := null;
1134: else
1135: select org_id
1136: into x_org_id
1137: from financials_system_parameters;
1138: end if;
1139: /* Cto Changes FPH end */
1140:
1141: IF x_organization_id IS NULL THEN

Line 1143: -- Get organization_id from financials_system_parameters.

1139: /* Cto Changes FPH end */
1140:
1141: IF x_organization_id IS NULL THEN
1142:
1143: -- Get organization_id from financials_system_parameters.
1144:
1145: SELECT inventory_organization_id
1146: INTO x_using_organization_id
1147: FROM financials_system_parameters;

Line 1147: FROM financials_system_parameters;

1143: -- Get organization_id from financials_system_parameters.
1144:
1145: SELECT inventory_organization_id
1146: INTO x_using_organization_id
1147: FROM financials_system_parameters;
1148:
1149: ELSE
1150: x_using_organization_id := x_organization_id;
1151: END IF;

Line 4991: -- Get organization_id from financials_system_parameters.

4987:
4988: l_progress := '030';
4989: IF x_dest_organization_id IS NULL THEN
4990:
4991: -- Get organization_id from financials_system_parameters.
4992:
4993: SELECT inventory_organization_id
4994: INTO x_organization_id
4995: FROM financials_system_parameters;

Line 4995: FROM financials_system_parameters;

4991: -- Get organization_id from financials_system_parameters.
4992:
4993: SELECT inventory_organization_id
4994: INTO x_organization_id
4995: FROM financials_system_parameters;
4996:
4997: ELSE
4998: x_organization_id := x_dest_organization_id;
4999: END IF;

Line 6232: FROM financials_system_parameters;

6228: SELECT org_id,
6229: inventory_organization_id
6230: INTO l_org_id,
6231: l_using_organization_id
6232: FROM financials_system_parameters;
6233: EXCEPTION
6234: WHEN OTHERS THEN
6235: null;
6236: END;

Line 6849: FROM financials_system_parameters;

6845: -- SQL Why : To calculate the currency conversion rate
6846:
6847: SELECT set_of_books_id
6848: INTO l_sob_id
6849: FROM financials_system_parameters;
6850:
6851: -- SQL What: Get the default currency exchange rate type from system parameters
6852: -- SQL Why : To calculate the currency conversion rate
6853:

Line 6864: FINANCIALS_SYSTEM_PARAMETERS FSP,

6860:
6861: SELECT nvl(FND.extended_precision,5)
6862: INTO l_base_curr_ext_precision
6863: FROM FND_CURRENCIES FND,
6864: FINANCIALS_SYSTEM_PARAMETERS FSP,
6865: GL_SETS_OF_BOOKS GSB
6866: WHERE FSP.set_of_books_id = GSB.set_of_books_id AND
6867: FND.currency_code = GSB.currency_code;
6868: