APPS.MIGRATE_BATCH dependencies on PS_WHSE_EFF

Line 4841: l_tran_whse ps_whse_eff.whse_code%TYPE;

4837: WHERE batch_id = v_batch_id;
4838:
4839: get_batch_info cur_get_batch_info%ROWTYPE;
4840: get_trans_rec cur_get_def_trans%ROWTYPE;
4841: l_tran_whse ps_whse_eff.whse_code%TYPE;
4842: l_batch_type pm_btch_hdr_bak.batch_type%TYPE;
4843: l_doc_type gme_inventory_txns_gtmp.doc_type%TYPE;
4844: l_pos NUMBER := 0;
4845: l_cnt NUMBER;

Line 4986: x_whse_code OUT NOCOPY ps_whse_eff.whse_code%TYPE

4982:
4983: PROCEDURE deduce_transaction_warehouse (
4984: p_transaction IN ic_tran_pnd%ROWTYPE,
4985: p_item_master IN ic_item_mst%ROWTYPE,
4986: x_whse_code OUT NOCOPY ps_whse_eff.whse_code%TYPE
4987: ) IS
4988: CURSOR cur_eff_whse (
4989: p_orgn_code VARCHAR2,
4990: p_item_id NUMBER,

Line 4994: FROM ps_whse_eff

4990: p_item_id NUMBER,
4991: p_line_type NUMBER
4992: ) IS
4993: SELECT whse_code
4994: FROM ps_whse_eff
4995: WHERE plant_code = p_orgn_code AND
4996: (whse_item_id IS NULL OR whse_item_id = p_item_id) AND
4997: ((p_line_type > 0 AND replen_ind = 1) OR
4998: (p_line_type < 0 AND consum_ind = 1)