APPS.CSI_T_TXN_LINE_DTLS_PVT dependencies on CSI_T_ORG_ASSIGNMENTS

Line 985: l_instance_ou_id csi_t_org_assignments.instance_ou_id%type;

981:
982: l_iir_ids_tbl csi_t_datastructures_grp.txn_ii_rltns_ids_tbl;
983: l_oa_ids_tbl csi_t_datastructures_grp.txn_org_assgn_ids_tbl;
984: l_oa_ind binary_integer;
985: l_instance_ou_id csi_t_org_assignments.instance_ou_id%type;
986:
987: CURSOR oa_cur(p_line_dtl_id in number) IS
988: SELECT *
989: FROM csi_t_org_assignments

Line 989: FROM csi_t_org_assignments

985: l_instance_ou_id csi_t_org_assignments.instance_ou_id%type;
986:
987: CURSOR oa_cur(p_line_dtl_id in number) IS
988: SELECT *
989: FROM csi_t_org_assignments
990: WHERE txn_line_detail_id = p_line_dtl_id;
991:
992: l_ea_ids_tbl csi_t_datastructures_grp.txn_ext_attrib_ids_tbl;
993: l_ea_ind binary_integer;

Line 1878: UPDATE csi_t_org_assignments

1874: WHEN no_data_found THEN
1875: l_instance_ou_id := null;
1876: END;
1877:
1878: UPDATE csi_t_org_assignments
1879: SET instance_ou_id = l_instance_ou_id
1880: WHERE txn_operating_unit_id = l_oa_cur_rec.txn_operating_unit_id;
1881:
1882: END IF;