[Home] [Help]
212: IF (l_ae_txn_rec.txn_src_type_id in (1,7,8) ) THEN
213:
214: /* The following Select statement has already been commented out.
215: The Select statement will still however be made to refer to the
216: CST_ORGANIZATION_DEFINITIONS as an impact of the HR-PROFILE option */
217:
218:
219: /* this new SELECT query below has been comented out because the above query had
220: been commented out.The only change being this new query refers to
217:
218:
219: /* this new SELECT query below has been comented out because the above query had
220: been commented out.The only change being this new query refers to
221: cst_organization_definitions.In the future if this above query needs to be
222: uncommented,please DO NOT uncomment the above query.Instead uncomment
223: this below query*/
224:
225: l_stmt_num := 28;
226: IF (l_ae_txn_rec.txn_src_type_id = 1) THEN
227:
228: SELECT NVL(operating_unit,-1)
229: INTO l_operating_unit
230: FROM cst_organization_definitions
231: WHERE organization_id = l_ae_txn_rec.organization_id;
232:
233: ELSIF (l_ae_txn_rec.txn_src_type_id IN (7,8)) THEN /* Internal req/internal order */
234:
245:
246: /* Select the operating unit of the org belonging to the processing cost group */
247: SELECT NVL(operating_unit,-1)
248: INTO l_operating_unit
249: FROM cst_organization_definitions
250: WHERE organization_id = decode(i_cost_group_id,
251: l_txn_cost_group_id, l_ae_txn_rec.organization_id,
252: l_ae_txn_rec.xfer_organization_id);
253: END IF;
687: l_stmt_num := 13;
688:
689: SELECT currency_code
690: INTO l_curr_rec.alt_currency -- currency of the sending org
691: FROM cst_organization_definitions
692: WHERE organization_id = decode(i_ae_txn_rec.txn_action_id,
693: 21, i_ae_txn_rec.organization_id,
694: i_ae_txn_rec.xfer_organization_id);
695: